ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Intra-pivot table calculations (https://www.excelbanter.com/excel-worksheet-functions/212867-intra-pivot-table-calculations.html)

PJFry

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