Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Here what I am trying to do. When I creating the Pivot Table, the table auto calculating the Grand Total field. What I am looking for the Differences from one month to another not the grand total. See example. This is what I have 2007-02-28 2008-02-28 Grand Total $100.00 $80.00 $180.00 $180.00 $310.00 $490.00 This is what I am looking to get.. 2007-02-28 2008-02-28 Diff $100.00 $80.00 -$20.00 $180.00 $310.00 $130.00 Can any one tell me how can I get the differences rather than the grand total? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
PIVOT TABLE - GRAND TOTAL COLUMN | New Users to Excel | |||
Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
Grand total in Pivot-Table | Excel Worksheet Functions |