Subtotals in Pivot table

[#1]

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..

[its_anandrjs]

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

If have some sample then provide.

[#3]

hi you can select subtotal at bottom in the presentation tab

[#4]

Hi Anand,

thanks for your reply....

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....

[#5]

Hi,

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

[its_anandrjs]

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.

[MK_QSL]

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

[SunilChauhan]

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

[jagan]

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.

[#10]

Thanks for all reply...

Here,I have attached the sample application....

Pls help me to achieve subtotal......