Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a way to compare a pivot table refreshed data to old one
I have a pivot table that I refresh twice a week. Is there a way to flag what
changed from the prvious time that data was uploaded? |
#2
|
|||
|
|||
You might be able to work around it in the following way.
Before you refresh, double click on the Grand Total of your pivot table. This will extract all the details that support that pivot table total. Then refresh your data, and repeat the process. Now in a seperat worksheet, copy/paste the old data in cell B1 (including headings). Label cell A1 with the word "when". Then starting in A2, all the way down to the bottom of your data range, input the word "before". Copy/paste your new data (without headings) at the bottom of this data range. Put the word "after" next to that set of data. Then run a new pivot table over both sets of data. You can then pivot over the "when" field and do a comparison. "Wes" wrote: I have a pivot table that I refresh twice a week. Is there a way to flag what changed from the prvious time that data was uploaded? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |