Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor II

Re: Total at the bottom of pivot table

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

reddys310
Honored Contributor II

Re: Total at the bottom of pivot table

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
New Contributor III

Re: Total at the bottom of pivot table

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"

rgvavihs
Valued Contributor

Re: Total at the bottom of pivot table

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

Re: Total at the bottom of pivot table

Hi Paticio,

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

Regards,

Ankit Jain

Not applicable

Re: Total at the bottom of pivot table

Hi RGV,

I need to export that data to excel.

Regards,

Ankit Jain

umartareen
Contributor

Re: Total at the bottom of pivot table

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

Community Browser