| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Compare Dates & calc. %
Is there a way in a Pivot table to compare 2 time frames, calculate the $
Amount of Change between these to dates, and then sort by the $ Amount of Change. I have figured out how to compare the 2 dates and was able to calculate the the change outside of the pivot table, but then I can not sort this in descending order. I think this calucation may need to be inside the pivot table to sort by it, but I do not know how to create the calculated field to compare the same data from one year against the same data from the next year. Company 2008 Sales 2009 Sales $ change ABC co 1000 1500 500 DEF co. 6000 6050 50 XZY Co. 5000 4500 -450 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Compare Dates & calc. %
Excel 2007 PivotTable
Yr to Yr change. Sort by change. Calculated Item (not Field) http://c0444202.cdn.cloudfiles.racks.../01_21_10.xlsm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table calc item | Excel Discussion (Misc queries) | |||
| Calc order in pivot table with COUNT | Excel Worksheet Functions | |||
| Pivot Table calc field problem | Excel Discussion (Misc queries) | |||
| Calc on Pivot Table | Excel Worksheet Functions | |||
| Pivot table to calc by group | Excel Discussion (Misc queries) | |||
Linear Mode
