6 Replies Latest reply: Dec 28, 2017 1:35 PM by Sunny Talwar

# Show Total and Average in pivot table or straight table

I would like to create a table that displays information like this:

Average10438.61%
Total3012---
Annie

10

220.00%
Bianca12758.33%
Charlie8337.50%

This is a simple task in Excel, but I cannot figure out how to do this in Qlik Sense. There are several challenges here:

• The most important thing is that there doesn't seem to be an option to do multiple totals lines, one for Total and one for Average. Is there a function I can use to achieve this instead?
• Pivot tables are cleaner and work better for what I am trying to do, but don't let you turn Total off per column when it isn't appropriate, like in the percentage table above. Is there a way around this in pivot tables, or do I need to use a straight table?
• ###### Re: Show Total and Average in pivot table or straight table

Check this out and see if this help

Percentage Subtotal

• ###### Re: Show Total and Average in pivot table or straight table

Nice solution, that's definitely thinking out of the box!

• ###### Re: Show Total and Average in pivot table or straight table

I am glad you like it

• ###### Re: Show Total and Average in pivot table or straight table

i have seen sunny doing it quite a few time in the community and i once applied it when all put their hands up and the team has  an illusion now that  i am the person who thinks out of the box. So passing the credit to you stalwar1.

• ###### Re: Show Total and Average in pivot table or straight table

Well I was not the one who started this (not sure who did), but I learnt this technique from kush141087... so passing along the credit to him

• ###### Re: Show Total and Average in pivot table or straight table

Thank you. I have not had time to fully explore this option, I'll come back with my results.