Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Subtotals in Pivot table

Hi everyone,

Need to add subtotal in pivot table

I have a Pivot table like this:

But i need to show subtotals like the following:

Can anyone help me to find solution for the above requirement..

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi

A simple method would be to create an inline Table using the Source field and giving the 'A-' records a value of 'A' and the remaining 3 a value of 'B'. Chose suitable field names to join with your main table. You can then use the new field with the A & B values as your first dimension and use subtotals on this field.

Regards

Dave

15 Replies
MVP

Go to properties >> Presentation >> Select Dimension >> Subtotals at bottom.

If have some sample then provide.

Not applicable
Author

hi you can select subtotal at bottom in the presentation tab

Not applicable
Author

Hi Anand,

After enabling Subtotals at bottom,I got the last row Total like this

But i need subtotal like this

pls suggest me  some other solutions....

Not applicable
Author

Hi,

Right Click on Pivot Table >> Go to Properties >> Presentation >> Dimensions And Expressions >> Select Dimension (Source) >> Click check Box Show Partial Sum.

MVP

Check how many dimension you have for that go to the presentation >> Dimension & expression and select dimension >> and then partial sum like ways do for rest of the dimension and you get its partial sum.

For each dimension you have to give partial sum.

MVP

Right Click on Pivot Table >> Presentation Tab >> Select Source From Dimensions and Expressions

>> Tick Show Partial Sum >> Select Subtotal at Bottom

Write Labels for Total as SUBTOTAL

Champion II

you can do subtotal only on the basis of field in dimention

but if you want subtotal in samefield that is bit difficult to find

then you can use like below

if(Source='A-Call in' or Source='A-SMS' or Source='A-Web', Subtotal,Source)

same for others and Total

hope this helps

Sunil Chauhan
Luminary Alumni

Hi,

How many Dimensions you have in your chart?  If you have second dimension then only you will get the Subtotals.  On what basis you want to generate the SubTotal?

Regards,

Jagan.

Not applicable
Author