A
Ash007
In a pivot table there is value coming from 2 different sources. So i have
put the "source" filed in Column and "value" in Data. Now Pivot table
generates grandtotal on the right hand which sums the value of the sources.
Now i am trying to get the difference between the two sources. I can write a
seperate formula outside Pivot table but i want it to be part of the pivot.
Can this be done? How can i get pivot table to do this? I am using Excel
version 2003. I try to attach some of the pivot table but it is not showing
properly (copy the below and paste in excel then you will some idea how the
pivot looks like). If anyone can help that would be appreciated.
------------------
Sum of MktValue Source
Portfolio Code Ticker ROUNDUP Prices (4) Aladdin Raw DD KPI DD Grand Total
0 12562 0.409 3766902 3766902
0.54 2134 2134
-----------------------
put the "source" filed in Column and "value" in Data. Now Pivot table
generates grandtotal on the right hand which sums the value of the sources.
Now i am trying to get the difference between the two sources. I can write a
seperate formula outside Pivot table but i want it to be part of the pivot.
Can this be done? How can i get pivot table to do this? I am using Excel
version 2003. I try to attach some of the pivot table but it is not showing
properly (copy the below and paste in excel then you will some idea how the
pivot looks like). If anyone can help that would be appreciated.
------------------
Sum of MktValue Source
Portfolio Code Ticker ROUNDUP Prices (4) Aladdin Raw DD KPI DD Grand Total
0 12562 0.409 3766902 3766902
0.54 2134 2134
-----------------------