Calculating Growth % in a Pivot Table

R

renee

How do you get growth % to calculate correctly at the total and/or subtotal
line? It is correct for each row but at the total is calculating it as a sum
of the rows above it.
 
I

ilia

Insert a calculated field. It will be something like:

=(ThisYear-LastYear)/LastYear

Adjusting for whatever fields and time periods you're using.

A calculated field subtotal is based on the subtotal of its precedent
fields, therefore should return the correct result.
 
Top