Pivot table field - difference from & %

[zanemc]

Hi

Refer book Pivot Tables : Data Crunching page 44 "Display change from year to year with difference from" : using the Pivot tbale field I'm able to display the difference between 2003 & 2004 revenue values.

Quesstion : I'd like to display not only the difference but the original revenue data values - How do I achieve this ??

The same applies to the % difference from

I'm also having problems in getting this to work on OLAP data - any suggestiions ?

 

[MrExcel]

You can add Revenue to the pivot table several times. In this case, three times.

Make one of them show the Difference From.
Make one of them be normal.
Make one of them be % of.

For OLAP data - I am not sure. I have never tried this and I am not sure of the limitations of OLAP for these types of calculations.

Bill Jelen

 

[zanemc]

Bill

I can get each of to work seperately but how do I get them all on the same table ?

Thanks
Zane

 

[MrExcel]

In Step 3 of the wizard, click the Layout button.

Drag your Revenue field to the data area three times.
The first is called Sum of Revenue.
The second is called Sum of Revenue2
The next is called Sum of Revenue3

Then, once you have the table, right click on a cell with Sum of Revenue2.
Choose Field Settings.
Click Options>>
Set it up as a % Difference.
Change the field name from Sum of Revenue2 to %ChangeFrom2005.

Repeat these steps to change Sum of Revenue3 to be a Difference from.

Bill