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: 
oanalung
Contributor III
Contributor III

QlikView / Pivot Table

hi, 

I have a pivot table as in the image below, I have moved Report Month column up so I can see the values as ccolumn headers and the calculations below the date. I want to add a new column that will calculate the total sum for all months for every row. 

if I add a Total with that calculation, will go under the month, not for all months. 

 

thank you!pivot.PNG

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

Hi

Try to enable the "Show Partial Sums" for "Report Month" under presentation tab. 

It will give the Total for the Month level 

MayilVahanan_0-1651139825270.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi

Try to enable the "Show Partial Sums" for "Report Month" under presentation tab. 

It will give the Total for the Month level 

MayilVahanan_0-1651139825270.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.