Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

GRAND TOTAL IN PIVOT TABLE

Hi friends

I have attached my qv document here. In my document I have sheet 'TB'. In this sheet I have created a pivot table. But I am unable to show value in Total Row although I have ticked 'Show partial sum' in the presentation tab. Kindly help me.

1 Solution

Accepted Solutions
sunny_talwar

Try these expressions with show partial sums checked

Sum(Aggr(if(sum(GLT_AMOUNT)>0,SUM(GLT_AMOUNT),0), GLT_AC_CODE, ACCOUNT_NAME))

and

Sum(Aggr(if(sum(GLT_AMOUNT)<0,SUM(GLT_AMOUNT)*-1,0), GLT_AC_CODE, ACCOUNT_NAME))

View solution in original post

1 Reply
sunny_talwar

Try these expressions with show partial sums checked

Sum(Aggr(if(sum(GLT_AMOUNT)>0,SUM(GLT_AMOUNT),0), GLT_AC_CODE, ACCOUNT_NAME))

and

Sum(Aggr(if(sum(GLT_AMOUNT)<0,SUM(GLT_AMOUNT)*-1,0), GLT_AC_CODE, ACCOUNT_NAME))