Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way in Pivot table to hide an expression column based on Dimensionality()? For example, in Conditional section of an expression can we put something like Dimensionality()=1 (i.e. when all the dimensions are collapsed)
I tried but it is not working. Is there any alternative for it?
You can´t use this function
Dimensionality() is evaluated "per row" and conditional are evaluated only once "per graph"
If you create an expression of just Dimensionality() then you can see the values it returns as per dimensions etc....
Yes Bill. I already created it and it showed values based on collapse/expansion of dimensions. I was wondering if I could make an expression column visible using this function. But I guess I won't be able to do that using dimensionality. I need to find another workaround. Thanks!