How to avoid showing data for lowest element in hierarchy?

[letileti]

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?

[jonathandienst]

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))     

[letileti]

Hi! Thanks for quick reply!

my data comes on X. The groups 1 2 3 are consolidation elements. Will the dimensionality approach work?