Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
timpoismans
Specialist
Specialist

Pivot Table - Column Totals

In a pivot table,

is there a way to create a single column that shows me the total value of all columns, without splitting them by measures?

For clarification:

this is my current situation:

Pivot Table Total 1.png

This is the situation I want to achieve (Pardon the aweful drawing skills):

Pivot Table Total 2.png

Thanks in advance.

Kind regards,

Tim

11 Replies
timpoismans
Specialist
Specialist
Author

I'm taking select parts out of my total through set analysis with every measurement, so if I use the same measure without the set analysis, I should get the total.

That might still differ from the total if I'd sum all my columns as there might be a calculation error in the measures, but if there's not, it should work like that.

agigliotti
MVP
MVP

let's try and let me know if you need some help.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it