Skip to main content
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.