Pivot subtotal problem

[sat_tok52]

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

[sunny_talwar]

Can you share the expression you are using?

[sat_tok52]

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

[sat_tok52]

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

[sunny_talwar · Accepted solution]

Try Adding Sum( before Aggr()

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

[sat_tok52]

Thanks Sunny