Calculating the difference between two rows of pivot table data

[NorthupL]

I have budget data that has 5 years of planned budgets for each program line in my portfolio that I want to compare with a new 5 year budget plan. Is there a way to get a pivot table or PowerPivot to calculate the difference between the two rows of data so I can see how much the new budget changed from the previous budget? (instead of calculating a subtotal, calculate a difference)

 

[Meckstss]

Not sure I understand what difference you want but try:

right click the data field column, select 'Value Field Settings...' In the resulting dialog box, select the 'Show Values As' tab then 'Difference From' and Base Item: previous.

Awesome tip, thanks for this

 

[tusharm]

You are welcome.

Awesome tip, thanks for this