# Calculated subtotals in Pivot table

Status
Not open for further replies.

#### emema0

##### New Member
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?

 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>

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Fluff

##### MrExcel MVP, Moderator
Status
Not open for further replies.

Replies
2
Views
1K
Replies
4
Views
744
Replies
0
Views
306
Replies
0
Views
26
Replies
1
Views
216

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