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 ...
Need Help
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.