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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a total column in a ident pivot table?

i have an iden pivot table and i want a column whit the total of hrs and ftes in the right, i try everything and dosen´t found well, any idea? sorry  for my english. i attached and example

5 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

If I understood you correctly. Try setting flag "Show partial sum" at the desired dimensions/expressions.

1.jpg

Regards,

Andrey

prma7799
Master III
Master III

Go to Presentation > check Show Partial Sum


Untitled.png


Totals in a PivotTable

Not applicable
Author

i´ve do it but i shows de total of each month, i want a column at the end with the total of all months of a row

Not applicable
Author

i´ve do it but it dosen´t make a column at the end with the total of the results of all months in  a row, i don´t know if the problem will be in the expresions o dimension that i have to select, its hard for me

Not applicable
Author

if i do it de column appears at the begining if i flag partial sums down it appears at the end but mi field comes from that:

country

     city1

     city2

to that:

     city1

     city2

country

also the ftes doesn´t sum properly

thanks for the answers

row at the end.JPG