| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Difference From
When I display years and I would like to know the Difference From previous in
either Excel 2003 or 2007, the values in the previous year do not display, only the resulting difference. Is it possible to display the previous year's values so the difference would make sense? Thanks for your assistance. -- I Teach |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables - Difference From
Drag a second instance of the field you are aggregating into the data area.
-- HTH... Jim Thomlinson "I Teach" wrote: When I display years and I would like to know the Difference From previous in either Excel 2003 or 2007, the values in the previous year do not display, only the resulting difference. Is it possible to display the previous year's values so the difference would make sense? Thanks for your assistance. -- I Teach |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the difference between VLookup and HLookup tables | Excel Discussion (Misc queries) | |||
| Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
