Create Variances using Pivot Table

[Guest]

Hi,

I am trying to find the variance % between the data using different months.
I was unable to figure out how I can show the variance by % using the Pivot
Table.

For example:

Current Data
Desc 01/01/2007 02/28/2007 03/31/2007
Ticket Sales $100.00 $120.00 $97.00

Looking for results:
Desc 01/01/2007 02/28/2007 Change in % 03/31/2007
Change in %
Ticket Sales $100.00 $120..00 +20% $97.00
-19%

Any suggustion?

 

[Roger Govier]

Hi

Drag another copy of your Data filed to the Data area.
Double click on field header>Advanced>Show Data as>%Difference from

Previous

On the PT, drag the Data icon and drop on Total so he values show side by
side.

 

[Guest]

Thank you Roger.

Could you clarify "drag the Data icon and drop on Total" how this can be
done. Which total do you mean? Please advise.

 

[Debra Dalgleish]

There's a description, with a picture, here:

http://www.contextures.com/xlPivot02.html

 

[Guest]

Thank you Debra. This is excetlly I was looking for.