Show Total and Average in pivot table or straight table
I would like to create a table that displays information like this:
Sales from Calls
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
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.