View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ilia ilia is offline
external usenet poster
 
Posts: 256
Default 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.