topic GRAND TOTAL IN PIVOT TABLE in QlikView

GRAND TOTAL IN PIVOT TABLE

upaliwije — Wed, 10 Apr 2019 08:40:15 GMT

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.

Re: GRAND TOTAL IN PIVOT TABLE

sunny_talwar — Wed, 10 Apr 2019 11:51:13 GMT

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))