Pivot Table Calculated Field/Item

[amolvijay]

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"..

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​