Calculating Growth % in a Pivot Table

  • Thread starter Thread starter renee
  • Start date Start date
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.
 
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.
 
Back
Top