![]() |
Pivot Table Comparison
Hi all,
I am hoping t get some help on this. I have two worksheets of monthly data (last month and current month) that gets updated at the end of each fiscal month. I pull the data into two pivot tables on the third sheet and am trying to put a formula together to compare the pivot table data. Here is an example of the data in each pivot table: In the old file: Charge Number 1234 was used for resource 12 ($300), resource 34 ($1,000) and resource 56 ($600). In the new file: Charge number 1234 was used for resource 12 ($800), resource 34 ($1,400), and resource 56 ($250). What I want to do is pull data into pivot table, find differences between the months and show the difference (delta) in a different column. The catch is that I want it set up for monthly use so I don't have to re-do formulas and workbooks every month. Also, not every esource is used eery month, so it has to be a little dynamic as well. Any suggestions? |
Pivot Table Comparison
Excel 2007 PivotTable
Find delta of 2 PTs on separate tabs. Four methods shown. http://c0718892.cdn.cloudfiles.racks.../04_28_10.xlsm Pdf preview of one method: http://www.mediafire.com/file/rzyym2atltm/04_28_10.pdf |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com