Calculating Growth % in a Pivot Table
 

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.

Calculating Growth % in a Pivot Table
 

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.


On Dec 13, 10:43 am, renee wrote:
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.