If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|