Pivot Table - % change for between running totals.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a pivot table with multiple calucalated fields. I need to be
able to calculate the % change between two of these columns, both are running
totals. I know that the formulas that I have used would, and do, work for any
other column, except those that are calculations themselves. Any ideas?
 
Hi David

Can you give an idea of the source data, what fields have been allocated to
the PT, and what formulae you have used in your calculated fields.
 
Hey Roger,

The columns I need to utilize for the % change are just running totals
calculated by using the field setttings and then options and then running
total. I am using 'week' as the column from which to reference. The
calculation is =(TTL POS $$ TY-TTL POS $$ YAGO)/TTL POS $$ YAGO. The only
thing that I have found is that because I am using, "calculated' fields", to
build this formula, that Excel may not allow this to work.

Thanks.
David
 
Back
Top