Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Intra-pivot table calculations
I have a pivot table that has part numbers as the row and months as the
column, with our margin on the parts for each month as the value. I want to calculate the delta between October and November so I can sort the table by the difference between those two months. Right now I copy and paste special values the pivot table and add in the column I want to calculate. I am thinking there has to be an easier way. Thoughts? Thanks! PJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculations | Excel Discussion (Misc queries) | |||
Pivot table Calculations | Excel Discussion (Misc queries) | |||
Calculations in Pivot Table. | Excel Worksheet Functions | |||
Pivot Table Calculations | Excel Discussion (Misc queries) | |||
Pivot Table calculations | Excel Discussion (Misc queries) |