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.
|