Multiple Totals coming after sorting column in Pivot table.

[Anonymous]

Hi all,

I have created a pivot table.

When I sort columns in the table then multiple Totals come on top.

I have used aggr function and also variable in Expressions.

[tresesco]

It seems that your table has partial sums enabled at various levels(dimensions). Check that in the presentation tab and uncheck  accordingly.

Thanks.

[Anonymous · Accepted solution]

Thanks tresesco

I checked at my end and tried solving the problem. First of all what you said works perfect for Pivot Tables. For Straight Tables I found that I had enabled totals at Dimensions as well as Expression totals... By disabling either one I am able to solve the problem

Hope this helps others facing similar problem in future.