Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear forum,
i have a hierarchy dimension ‘Group’ existing out of several levels - lowest level is X
we should show Actuals and Budget Information except for level X where we show Actuals only ( we leave Budget blank or if possible have the measure hidden)
Example:
GROUP ACT BUD
Gr 1 X X
Gr 2 X X
Gr 3 X X
X X Blank/or hiden
Someone who knows how to?
If there are no budgets linked to the lowest level, then the Budget cell will be null already. If you want to suppress a non-zero value for the 'X', then you could use Dimensionality() to detect the hierarchy level. Something like this for the budget expression:
If (Dimensionality() < 4, Sum(Budget))
Hi! Thanks for quick reply!
my data comes on X. The groups 1 2 3 are consolidation elements. Will the dimensionality approach work?