Condicional Expression - Last expand

[#1]

I have a expression that is conditional and only appear when I expand the last column of dimension, how to do this? Thanks.

[Jason_Michaelides]

If(Dimensionality()=YourLastDimensionNumberHere,YourExpressionHere)

Hope this helps,

Jason

[#3]

Thanks, but i put this expression in condicional field?

[#4]

You can give me someone example (qvw file)?

[Jason_Michaelides · Accepted solution]

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.

[#6]

OK, but the column don't disappear, i think with this function the column with expression just appear when dimensionality() = 3...

[Jason_Michaelides]

You could try adding in the Null bit -

If(Dimensionality()=3,Sum(Sales),Null())