Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try maybe
=Exp(Sum(Log( aggr( count(distinct value),dim))))
Thanks,
Mathematics is the queen of sciences!
regards
Darek
genial !