Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
It seems that your table has partial sums enabled at various levels(dimensions). Check that in the presentation tab and uncheck accordingly.
Thanks.
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.