Column Totals displaying incorrect values in Pivot Table

[analyticsuser]

Hello all,

We have a requirement where I need to display column totals in a Pivot table based on a dimension. I'm using

avg(sum(aggr(Measures,dimensions))) to calculate individual column values and getting the right numbers, for Totals, I need a sum of all individual columns but it's doing a average.

any help would be greatly appreciated. Thanks in advance.

[marcus_sommer · Accepted solution]

Try it with:

sum(aggr(avg(aggr(Measures,dimensions)),dimensions))

- Marcus

[analyticsuser]

Thank you, Marcus. It worked!