Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))