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?
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
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?
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 |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
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% |
<tbody>
</tbody>