PIVOT Table Subtract Between Rows

[ChetanPuri]

Hello Excel Gurus,

Just wondering if there is a way in Pivot table to Subtract expenses from Revenue for Each category. For example in row D14 Onwards its a total for Revenue and expenses and I want to show revenue- expense, is there a way I can add formula in Pivot table for each category

Budget by Location - 13 March 2024.xlsx
	D	E	F	G	H	I
1
2
3	Month
4	Jul- 2024	Aug - 2024	Sep-2024	Oct - 2024	Nov - 2024	Dec - 2024
5	28,579.30	35,724.13	28,579.30	28,579.30	36,744.82	28,579.30
6	671.7155954	671.7155954	671.7155954	671.7155954	671.7155954	671.7155954
7	304.6605567	304.6605567	304.6605567	304.6605567	304.6605567	304.6605567
8
9
10	18105.54166	18105.54166	18105.54166	18105.54166	18105.54166	18105.54166
11	1548.82479	1548.82479	1548.82479	1548.82479	1548.82479	1548.82479
12
13
14	49,210.05	56,354.87	49,210.05	49,210.05	57,375.56	49,210.05
Sheet7

 

[number kruncher]

I have done this with bringing the expenses into the PT as negative values.

Hope this helps

nk