Multiplication of aggregation results

[#1]

Hello,

I am looking for an idea how to calculate the number of combinations of elements designated with respect to certain dimension.

Let's say for example that the dimension coordinates are:
A, B, C, D

Expression:
Aggr (count (distinct value), dim)
gave the results:
A-2
B-3
C-4
D-2

I wish to make on the basis of the next calculation, which will result in multiplying these values ​​by themselves, so that as a result I get:
2 * 3 * 4 * 2 = 48

Thank you in advance for your suggestions.
regards
Darek

[swuehl · Accepted solution]

Try maybe

=Exp(Sum(Log( aggr( count(distinct value),dim))))

[#3]

Thanks,
Mathematics is the queen of sciences!

regards

Darek

[MarcoWedel]

genial !

[#5]