topic How to avoid showing data for lowest element in hierarchy? in App Development

How to avoid showing data for lowest element in hierarchy?

letileti — Sat, 16 Nov 2024 21:32:28 GMT

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?

Re: How to avoid showing data for lowest element in hierarchy?

jonathandienst — Fri, 25 Jan 2019 06:22:18 GMT

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

Re: How to avoid showing data for lowest element in hierarchy?

letileti — Fri, 25 Jan 2019 07:57:48 GMT

Hi! Thanks for quick reply!

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