Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Facing an issue to do calculation between two fields of two different pivot tables, because there is no common key.
The scenario is as below
First Pivot Table: Second Table
campaign Year 2013 2014 Subscribed Year 2013 2014
Camp Quarter Q1 Q2 Q3 Q1 Q2 Q3 Sub Quarter Q1 Q2 Q3 Q1 Q2 Q3
A1 2 4 6 1 4 5 A1 3 5 9 1 4 5
A2 3 3 4 2 5 7 A2 4 6 7 2 5 6
Output Should be Sum of values for particular quarter
Output Year 2013 2014
Q1 Q2 Q3 Q1 Q2 Q3
A1 5 9 15 2 8 10
A2 7 9 11 4 10 13
Please note A1 ,A2 ,Subscribed Year,Campaign Year and the quarters are calcaluted dimensions.
Please let me know how to solve this.