Total at the bottom of pivot table

[#1]

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

[satishkurra]

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

[reddy-s]

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]

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]

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.

[#6]

Hi Paticio,

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

Regards,

Ankit Jain

[#7]

Hi RGV,

I need to export that data to excel.

Regards,

Ankit Jain

[umartareen]

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