Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customise Pivot Tables Fields
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 ----------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Fields in Pivot Tables | Excel Worksheet Functions | |||
Pivot tables - calculated fields | Excel Worksheet Functions | |||
pivot tables - calculated fields | Excel Worksheet Functions | |||
row fields in pivot tables | Excel Discussion (Misc queries) | |||
Pivot tables - custom fields | Excel Discussion (Misc queries) |