Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have problem with aggr function. I used this function to aggregate Volume per Customer and his products.
sum(aggr(
sum([Volume AY])
/sum({<[Product Group]=>}(aggr(sum(([Volume AY])),Customer)))
,Customer,[Product Group]))
It works, but it takes (aggr) only one value (one product). Other values show as zero.
Where is the mistake? Why takes only one value?
Thanks for advice.
T.
Why can't you use Product and Customer as dimensions and sum([Value AY]) as expression?
What's the purpose of this nest of nested sums?