Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a expression that is conditional and only appear when I expand the last column of dimension, how to do this? Thanks.
Say you have 3 dimensions in the pivot table and your expression to only calculate if the last one is expanded is Sum(Sales)....
Instead of Sum(Sales) as the expression, use:
If(Dimensionality()=3,Sum(Sales))
The third part of the IF() statement (the ELSE bit) is absent (Null) so the expression shouldn't appear at all.
If(Dimensionality()=YourLastDimensionNumberHere,YourExpressionHere)
Hope this helps,
Jason
Thanks, but i put this expression in condicional field?
You can give me someone example (qvw file)?
Say you have 3 dimensions in the pivot table and your expression to only calculate if the last one is expanded is Sum(Sales)....
Instead of Sum(Sales) as the expression, use:
If(Dimensionality()=3,Sum(Sales))
The third part of the IF() statement (the ELSE bit) is absent (Null) so the expression shouldn't appear at all.
OK, but the column don't disappear, i think with this function the column with expression just appear when dimensionality() = 3...
You could try adding in the Null bit -
If(Dimensionality()=3,Sum(Sales),Null())