Discussion board where members can get started with Qlik Sense.
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.
As a work around, you can create the expected expression in a text object and display below the chart...
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.
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"
Try with text boxes and place them on totals.If you export this to excel you wont get data in text boxes in excel.
I asked how can we do it in qliksese, not qlikview.
I need to export that data to excel.
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.