Calculated subtotals in Pivot table

Status
Not open for further replies.

emema0

New Member
Joined
Jan 18, 2019
Messages
4
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?

AccountAccountclassPeriosBalanceBudget
3010IncomeJan500500
3010IncomeFeb1000900
3010IncomeMar800800
3020IncomeJan300250
3020IncomeFeb250300
3020IncomeMar300500
7010Personnel CostJan-250-250
7010Personnel CostFeb-250-250
7010Personnel CostMar-250-250
4010ExpensesJan-50-20
4010ExpensesFeb-60-60
4010ExpensesMar-100-100

<tbody>
</tbody>


FilterPeriodJan
RowlabelsSum of BalanceSum of Budget
Incomes800750
3010500500
3020300250
Personnel Cost-250-250
7010-250-250
Expenses-50-20
4010-50-20
Grand total500480

<tbody>
</tbody>



FilterPeriodJan
RowlabelsSum of BalanceSum of Budget
Incomes800750
3010500500
3020300250
Personnel Cost-250-250
7010-250-250
A/I%320%300%
Expenses-50-20
4010-50-20
Grand total500480
TG%160%156,25%

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,108,987
Messages
5,526,069
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top