anurag1720
New Member
- Joined
- Apr 8, 2015
- Messages
- 1
I have two separate pivot tables with same row labels but different report filters. I would like to combine these two pivot tables together and get a the difference in values. Please see below for example, I have the sample table and would like and then I made 2 Pivot Tables based on the data using different report filters and get the final output in a pivot table instead of manual calculations. Thanks
Sample Data:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>Pivot Table 1:
Pivot Table 2:
Output:
Sample Data:
Product Name | Manager | Engineer | Approval Date | Issues | Turned Up |
G_1 | A | X | 6/17/2015 | Yes | |
G_2 | B | X | Yes | ||
G_3 | C | X | 6/17/2015 | ||
G_4 | D | X | Yes | ||
G_5 | A | Y | 6/17/2015 | Yes | |
G_6 | B | Y | Yes | ||
G_7 | C | Y | 6/17/2015 | Yes | |
G_8 | D | Y | |||
G_9 | A | Z | |||
G_10 | B | Z | 6/17/2015 | Yes | |
G_11 | C | Z | 6/17/2015 | ||
G_12 | D | Z | |||
G_13 | A | Q | Yes | ||
G_14 | B | Q | 6/17/2015 | Yes | |
G_15 | C | Q | |||
G_16 | D | Q | 6/17/2015 | Yes | |
G_17 | A | X | 6/15/2015 | ||
G_18 | B | Y | 6/16/2015 | Yes | |
G_19 | C | Z | 6/12/2015 | Yes | |
G_20 | D | Q | 6/18/2015 | ||
G_21 | A | Z | 6/19/2015 | Yes | |
G_22 | B | Y | 6/20/2015 | ||
G_23 | C | X | 6/21/2015 | Yes | |
G_24 | D | Q | 6/22/2015 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Pivot Table 2:
Output: