Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to show columns in a table when a state of hierachy appear, here " Code article"
So I want to appear this column :
when we are at the "Code article" level
does it possible or not ? Can you help me ?
Best regard
Create a Calculated Dimension:
=If(Match(HierarchyField, 'Code article'), YourDimension, '-')
Replace YourDimension
with the dimension you want to display when the hierarchy is at the "Code article" level.
You can do a similar thing with Calculated measure too
As far as I know this is not something you can reference in itself, but you can make a column visible only when Count(distinct [Niveau 5])=1, which should provide the same result under most circumstances.
Sadly, it doesn't work Count(distinct [Niveau 5])=1
and if I write >=1 then
The column appear for the other hierachy
Create a Calculated Dimension:
=If(Match(HierarchyField, 'Code article'), YourDimension, '-')
Replace YourDimension
with the dimension you want to display when the hierarchy is at the "Code article" level.
You can do a similar thing with Calculated measure too
Sorry, How can you add an Hierarchy dimension in a Calculated Dimension ?