Forum Discussion

david_avgarcia's avatar
david_avgarcia
Frequent Visitor
9 months ago
Solved

Matrix Show Different Hierarchy Levels

I'm using a matrix to the display the following table: Country | Section | Header | Clause Belgium | Scope  |              | This is the scope  Belgium | Benefits | Tax       | Exemption from all ...
Need Help
  • danextian's avatar
    danextian
    9 months ago

    Hi david_avgarcia 

    Use ISINSCOPE to determine check whether a column is the level in a hierarchy of levels. In the image below, Gross Profit is already expanded but the next level in the hierarchy is not visible. A condition was applied to return the second level as blank when it is in scope and the first level is Gross Profit.

     

    IF (
    ISINSCOPE ( tbl[hierarchy2] )
        && SELECTEDVALUE ( tbl[hierarchy1] ) = "Gross Profit",
    blank,
    [pnl measure]
)

     

david_avgarcia's avatar
david_avgarcia
Frequent Visitor
9 months ago

danextian , I think your solution could work. Could you please confirm how did you manage to hide the blank rows? It was not setting that measure as a filter right?