Calculated subtotals in pivot table

[Anonymous]

I want to add calculated subtotals into a pivot table
Like in a finicial report you want to se Margins after different categories

I have the scenario in the tabels below. My datatable is added to the datamodel as connections only.

A table with balance per account, I have created an "Income statement report" in a pivot now I would like to add the 2 subtotals that are seen in the copy of the pivot A/I% and TG%
Is this possible? 

Account	Accountclass	Perios	Balance	Budget
3010	Income	Jan	500	500
3010	Income	Feb	1000	900
3010	Income	Mar	800	800
3020	Income	Jan	300	250
3020	Income	Feb	250	300
3020	Income	Mar	300	500
7010	Personnel Cost	Jan	-250	-250
7010	Personnel Cost	Feb	-250	-250
7010	Personnel Cost	Mar	-250	-250
4010	Expenses	Jan	-50	-20
4010	Expenses	Feb	-60	-60
4010	Expenses	Mar	-100	-100

Filter	Period	Jan
Rowlabels		Sum of Balance	Sum of Budget
Incomes		800	750
	3010	500	500
	3020	300	250
Personnel Cost		-250	-250
	7010	-250	-250
Expenses		-50	-20
	4010	-50	-20
Grand total		500	480

Filter	Period	Jan
Rowlabels		Sum of Balance	Sum of Budget
Incomes		800	750
	3010	500	500
	3020	300	250
Personnel Cost		-250	-250
	7010	-250	-250
A/I%		320%	300%
Expenses		-50	-20
	4010	-50	-20
Grand total		500	480
TG%		160%	156,25%

[v-lili6-msft]

hi, @Anonymous 

For add a custom column/row in matrix visual, I'm afraid it couldn't achieve in Power BI for now.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.

Best Regards,

Lin