Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
60
Views
Topic starter
Hello,
I have two pivot tables above each other, and I am trying to calculate the difference between the two values.
The pivot tables contain a filter on each other on the row labels, which means that some are items are contained in one table and not the other.
As such calculating the difference between the two tables, using an if function is not producing the results.
Is there anyway around this please?
My data looks something like below;
| A | 1 | 2 | 3 | 4 |
| B | ||||
| C | ||||
| D | ||||
| Grand Total | ||||
| A | 1 | 2 | 3 | 4 |
| C | ||||
| F | ||||
| G | ||||
| I | ||||
| T | ||||
| Grand Total | ||||
| A | 1 | 2 | 3 | 4 |
| B | ||||
| C | ||||
| D | ||||
| F | ||||
| G | ||||
| I | ||||
| T | ||||
| Grand Total | ||||
Posted : 01/12/2020 6:58 am
Hello,
Can you upload a sample file? Much easier to give good response.
Do you need to compare between the pivot tables? Can’t you do the comparison from the data that feeds the pivot tables?
Br,
Anders
Posted : 01/12/2020 3:27 pm
