Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total at the bottom of pivot table

Hi,

1. Is there any way of showing totals at the bottom in pivot table?

2. Can i write a custom calculation for total like i have a interest percentage coulmn  in the pivot table and i want to show the average interest at the bottom.

Like for the attache screenshot.

1. i want to show the total of balance at the bottom and average of rate at the bottom.

Waiting for reply.

Regards,

Ankit Jain

7 Replies
satishkurra
Specialist II
Specialist II

As a work around, you can create the expected expression in a text object and display below the chart...

reddy-s
Master II
Master II

Hi Ankit,

You can not have grand totals in a pivot table but you have workarounds or even go with an extension which can get your purpose. Check Qlikbranch if there is something which can full fill your requirement.

Thanks,

Sangram.

patricio
Contributor III
Contributor III

Create 2 expressions. Sum(Balance) and Avg(Rate). then in the pivot table properties/Presentation

Click in your first dimension to have it selected and then select "Show Partial Sums" and "Subtotals at Bottom"

Anonymous
Not applicable
Author

Hi

Try with text boxes and place them on totals.If you export this to excel you wont get data in text boxes in excel.

Not applicable
Author

Hi Paticio,

I asked how can we do it in qliksese, not qlikview.

Regards,

Ankit Jain

Not applicable
Author

Hi RGV,

I need to export that data to excel.

Regards,

Ankit Jain

umartareen
Creator II
Creator II

Hi,


Not sure if its possible with a QS Pivot chart at the moment, but a workaround can be made.

Check this out QS pivot table : How to get totals at the bottom?  This could provide more insight.

Regards,

Umar