Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use dimentionality and total to count the instances of each dimension by the dimension in column a.
currently able to get the first instance of the count using
=if(Dimensionality()=1,count(total< [Category]> Category_desc) but need to expand this to calculate on mutliple dimensions.
I'm not sure if you really need the total within the count() and would rather expect that distinct would be useful. Therefore I could imagine that you use something like this:
if(dimensionality() = 1, count(distinct Category_desc&AnotherField), ...)
- Marcus