Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try it with:
sum(aggr(avg(aggr(Measures,dimensions)),dimensions))
- Marcus
Try it with:
sum(aggr(avg(aggr(Measures,dimensions)),dimensions))
- Marcus
Thank you, Marcus. It worked!