Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead 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

View solution in original post

15 Replies
its_anandrjs

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,

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

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.

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

SunilChauhan
Champion II
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
jagan
Luminary Alumni
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

Thanks for all reply...

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

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