Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Relative growth in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table % Growth Calculation | Excel Discussion (Misc queries) | |||
Calculating Hypothetical Growth of $10,000 in Excel | Excel Discussion (Misc queries) | |||
Calculating Compounded Growth Rates | Excel Worksheet Functions |