Aggr function problem

[#1]

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.

[Gysbert_Wassenaar]

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?