Intra-pivot table calculations

P

PJFry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot table 0
Pivot Table Data Aggregation 0
DATE Calculations in pivot table 0
Excel does not accept text format! 0
Pivot Table Comparison 1

Top