Hi All:
I have a table that is as simple as this:
P1 P2
2004 Actual 250 350
2005 Actual 500 400
I just want to automatically add a third line using the calculated fields in pivot tables called Variance which is 2005 actual - 2004 actual. The problem is the two rows 2005 actual and 2004 actual are not there in the options list to calculate.
Can someone please explain how i can add the third line called variance automatically using calculated fields.
I have a table that is as simple as this:
P1 P2
2004 Actual 250 350
2005 Actual 500 400
I just want to automatically add a third line using the calculated fields in pivot tables called Variance which is 2005 actual - 2004 actual. The problem is the two rows 2005 actual and 2004 actual are not there in the options list to calculate.
Can someone please explain how i can add the third line called variance automatically using calculated fields.