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 |
All times are GMT +1. The time now is 01:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com