Pivot Table - % change for between running totals.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David D - 07 Aug 2007 16:28 GMT

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?

Reply to this Message

Roger Govier - 07 Aug 2007 18:02 GMT

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.

Signature

Regards
Roger Govier

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

Reply to this Message

David D - 07 Aug 2007 18:40 GMT

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

> Hi David
>
[quoted text clipped - 7 lines]
> > any
> > other column, except those that are calculations themselves. Any ideas?

Reply to this Message

Rate this thread: