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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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