Hi Experts
Need your help..
I have table/s with Financial Year, Quarter wise revenue data... Table "A", "B" and "C".... There is one more table having Total Contract Value for each of the contract. I want to create a Pivot table which will display the TVC and Rev for particular Financial year in one table..
I did created consolidated pivot table using "Connections"..
Need your help..
I have table/s with Financial Year, Quarter wise revenue data... Table "A", "B" and "C".... There is one more table having Total Contract Value for each of the contract. I want to create a Pivot table which will display the TVC and Rev for particular Financial year in one table..
I did created consolidated pivot table using "Connections"..
| Table A | Table B | Table C | |||||||||||
| Financial Year | Quarter | Contract ID | Rev | Financial Year | Quarter | Contract ID | Rev | Financial Year | Quarter | Contract ID | Rev | ||
| FY25 | Q125 | B-201 | 150 | FY24 | Q124 | B-201 | 140 | FY23 | Q123 | B-201 | 130 | ||
| FY25 | Q225 | B-201 | 151 | FY24 | Q224 | B-201 | 130 | FY23 | Q223 | B-201 | 125 | ||
| FY25 | Q325 | B-202 | 152 | FY24 | Q324 | B-202 | 120 | FY23 | Q323 | B-202 | 145 | ||
| FY25 | Q425 | B-203 | 153 | FY24 | Q424 | B-203 | 110 | FY23 | Q423 | B-203 | 135 | ||
| FY25 | Q125 | B-201 | 154 | FY24 | Q124 | B-201 | 100 | FY23 | Q123 | B-201 | 125 | ||
| FY25 | Q225 | B-201 | 155 | FY24 | Q224 | B-201 | 125 | FY23 | Q223 | B-201 | 120 | ||
| FY25 | Q325 | B-202 | 156 | FY24 | Q324 | B-202 | 135 | FY23 | Q323 | B-202 | 117 | ||
| FY25 | Q425 | B-203 | 157 | FY24 | Q424 | B-203 | 145 | FY23 | Q423 | B-203 | 120 |
| Contract ID | TVC | FY23 | FY24 | Fy25 |
| B-201 | 1830 | 200 | 400 | 400 |
| B-202 | 2000 | 400 | 800 | 800 |
| B-203 | 3000 | 600 | 1200 | 1200 |
| This Rev I wish to have for only FY23 | ||||
| from Table A, B and C ↓ | ||||
| Row Labels | Sum of Rev | Sum of TVC | ||
| B-201 | 1830 | 1830 | ||
| B-202 | 924 | 2000 | ||
| B-203 | 930 | 3000 | ||
| Grand Total | 3684 | 6830 | ||
