ChetanPuri
Board Regular
- Joined
- Sep 5, 2018
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
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
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 |