View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJFry PJFry is offline
external usenet poster
 
Posts: 143
Default 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