Create Variances using Pivot Table

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

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

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

On the PT, drag the Data icon and drop on Total so he values show side by
side.
 
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.
 
Back
Top