Calculated subtotals in Pivot table

[emema0]

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 with connection 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?

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Account[/TD]
[TD]Accountclass[/TD]
[TD]Perios[/TD]
[TD]Balance[/TD]
[TD]Budget[/TD]
[/TR]
[TR]
[TD]3010[/TD]
[TD]Income[/TD]
[TD]Jan[/TD]
[TD]500[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]3010[/TD]
[TD]Income[/TD]
[TD]Feb[/TD]
[TD]1000[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]3010[/TD]
[TD]Income[/TD]
[TD]Mar[/TD]
[TD]800[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]3020[/TD]
[TD]Income[/TD]
[TD]Jan[/TD]
[TD]300[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]3020[/TD]
[TD]Income[/TD]
[TD]Feb[/TD]
[TD]250[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]3020[/TD]
[TD]Income[/TD]
[TD]Mar[/TD]
[TD]300[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]7010[/TD]
[TD]Personnel Cost[/TD]
[TD]Jan[/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD]7010[/TD]
[TD]Personnel Cost[/TD]
[TD]Feb[/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD]7010[/TD]
[TD]Personnel Cost[/TD]
[TD]Mar[/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD]4010[/TD]
[TD]Expenses[/TD]
[TD]Jan[/TD]
[TD]-50[/TD]
[TD]-20[/TD]
[/TR]
[TR]
[TD]4010[/TD]
[TD]Expenses[/TD]
[TD]Feb[/TD]
[TD]-60[/TD]
[TD]-60[/TD]
[/TR]
[TR]
[TD]4010[/TD]
[TD]Expenses[/TD]
[TD]Mar[/TD]
[TD]-100[/TD]
[TD]-100[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Filter[/TD]
[TD]Period[/TD]
[TD]Jan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rowlabels[/TD]
[TD][/TD]
[TD]Sum of Balance[/TD]
[TD]Sum of Budget[/TD]
[/TR]
[TR]
[TD]Incomes[/TD]
[TD][/TD]
[TD]800[/TD]
[TD]750[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3010[/TD]
[TD]500[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3020[/TD]
[TD]300[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]Personnel Cost[/TD]
[TD][/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7010[/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD]Expenses[/TD]
[TD][/TD]
[TD]-50[/TD]
[TD]-20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4010[/TD]
[TD]-50[/TD]
[TD]-20[/TD]
[/TR]
[TR]
[TD]Grand total[/TD]
[TD][/TD]
[TD]500[/TD]
[TD]480[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Filter[/TD]
[TD]Period[/TD]
[TD]Jan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rowlabels[/TD]
[TD][/TD]
[TD]Sum of Balance[/TD]
[TD]Sum of Budget[/TD]
[/TR]
[TR]
[TD]Incomes[/TD]
[TD][/TD]
[TD]800[/TD]
[TD]750[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3010[/TD]
[TD]500[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3020[/TD]
[TD]300[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]Personnel Cost[/TD]
[TD][/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7010[/TD]
[TD]-250[/TD]
[TD]-250[/TD]
[/TR]
[TR]
[TD]A/I%[/TD]
[TD][/TD]
[TD]320%[/TD]
[TD]300%[/TD]
[/TR]
[TR]
[TD]Expenses[/TD]
[TD][/TD]
[TD]-50[/TD]
[TD]-20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4010[/TD]
[TD]-50[/TD]
[TD]-20[/TD]
[/TR]
[TR]
[TD]Grand total[/TD]
[TD][/TD]
[TD]500[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD]TG%[/TD]
[TD][/TD]
[TD]160%[/TD]
[TD]156,25%[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...tals-pivot-table-post5232680.html#post5232680

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).