Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 73
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating growth with negative numbers Tsipi4me Excel Worksheet Functions 3 April 3rd 23 12:12 PM
Relative growth in pivot table ChadBellan Excel Discussion (Misc queries) 0 May 31st 07 02:00 PM
Pivot Table % Growth Calculation [email protected] Excel Discussion (Misc queries) 3 February 21st 07 02:17 AM
Calculating Hypothetical Growth of $10,000 in Excel WxNoleMO Excel Discussion (Misc queries) 3 January 26th 07 07:50 PM
Calculating Compounded Growth Rates Beauwebber Excel Worksheet Functions 1 June 12th 06 11:57 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"