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
|