Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table sum of all in a column at the end of all columns

HI,

I have a pivot table with one dimension on rows (City) and a Employee dimension on columns. Thus each column in pivot is presenting a seperate employe. I want to add a column at the end, which shows the sum of values in all employees for the city in that row. The values are an expression showing the count of incidents on a specific date.

So basically the ending column shows the sum of all incidents for city that is in that row for all employees. How can I add the total column in the end?

total column.PNG

Arif

1 Reply
Not applicable
Author

you need to check show sub total in the presentation tab for your second dimension