topic Re: Pivot subtotal problem in QlikView

Pivot subtotal problem

sat_tok52 — Wed, 24 Feb 2016 13:45:40 GMT

Hi Guru's

I am using pivot table ,but my pivot is unable to display total.I have two dimension and one expression and also have checked show partial sum check box in presentation still it's not .attaches is the screen shot

any help.

Thanks,

Sateesh

Re: Pivot subtotal problem

sunny_talwar — Wed, 24 Feb 2016 13:47:32 GMT

Can you share the expression you are using?

Re: Pivot subtotal problem

sat_tok52 — Wed, 24 Feb 2016 13:48:45 GMT

=Aggr(sum( {<bucket={'Open / O/N'}>}AMT),purpose,subclassification)

Re: Pivot subtotal problem

sat_tok52 — Wed, 24 Feb 2016 13:49:41 GMT

=Aggr(sum( {<bucket={'Open / O/N'}>}AMT),purpose,subclassification)

Re: Pivot subtotal problem

sunny_talwar — Wed, 24 Feb 2016 13:51:35 GMT

Try Adding Sum( before Aggr()

=Sum(Aggr(Sum({<bucket={'Open / O/N'}>}AMT), purpose, subclassification))

Re: Pivot subtotal problem

sat_tok52 — Wed, 24 Feb 2016 13:55:00 GMT

Thanks Sunny