Forum Discussion

PaddyHS's avatar
PaddyHS
Frequent Visitor
3 years ago

Show only values at the second level down in a matrix

 

 

 

 

 

I have a Matrix with rows based on a Division > Cost Center Hierarchy (Engineering and Finance are at the Division Level).  I would like to show the SEC Class value on the right but only for the Cost Center Level.  That is to say, the values to the right of Engineering and Finance would be blank while the values below for the respective Cost Centers will have the SEC value.  

Need Help

5 Replies

  • hnguy71's avatar
    hnguy71
    Icon for Super User rankSuper User
    3 years ago

    Hi PaddyHS ,

     

    In this case you would use a function called ISINSCOPE to check. You'll use it against your second level.

     

    VAR _InScope = ISINSCOPE(YOUR_TABLE[Cost Center])
RETURN
IF( _InScope, SUM(YOUR_TABLE[Value]) )

     

     

    • PaddyHS's avatar
      PaddyHS
      Frequent Visitor
      3 years ago

      This script throws the visual off.  Could it be that you're summing a categorical variable with the SEC Class field?  I just want to display whatever value is associated with the respective cost center with the Division level remaining blank.  

      • hnguy71's avatar
        hnguy71
        Icon for Super User rankSuper User
        3 years ago

        PaddyHS 
        Can you explain "throws the visual off"?

        Could you elaborate on your issue?

        Would you happen to be able to share some sample data and expected results?

         

        From my test below it does work.