Forum Discussion
Calculated subtotals in pivot table
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% |
1 Reply
v-lili6-msftCommunity Support
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