topic Re: Show Total and Average in pivot table or straight table in App Development

Show Total and Average in pivot table or straight table

Anonymous — Wed, 27 Dec 2017 18:09:53 GMT

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

Employee	Calls Made	Sales Made	Sales from Calls
Average	10	4	38.61%
Total	30	12	---
Annie	10	2	20.00%
Bianca	12	7	58.33%
Charlie	8	3	37.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

sunny_talwar — Wed, 27 Dec 2017 18:24:22 GMT

Check this out and see if this help

Percentage Subtotal

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

luismadriz — Wed, 27 Dec 2017 22:50:02 GMT

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

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

sunny_talwar — Wed, 27 Dec 2017 23:35:26 GMT

I am glad you like it

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

Anonymous — Thu, 28 Dec 2017 18:02:46 GMT

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

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

pradosh_thakur — Thu, 28 Dec 2017 18:25:49 GMT

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

sunny_talwar — Thu, 28 Dec 2017 18:35:00 GMT

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

sudhir0538 — Sat, 20 Apr 2019 07:03:27 GMT

Hi Sunny , It's really a great Stuff !

Can you help in my case. Details are mentioned in attached Excel format where sheet 1 is my input data and my sheet 2 are my expected output with Avg file.

Pls help to achieve this.