Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Help with workers hierarchy in Matrix

I would like to have sorted data in Matrix visual where I will have hierarchy - Director -> Regional Manager -> Unit Manager ->Agent.

Now every data is in one table.

Example:

 

How to do this???

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for your help. I think I managged this in Power Query.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,
    From what I know, combined with the data you provided, it doesn't seem possible to accomplish the goal of displaying the hierarchy in a matrix, but if you want to do an accumulation calculation on the data, you can do it using this measure:

     

    Column = 
CALCULATE(
    SUM('Table'[ITEM SOLD]),
    FILTER(
        ALL('Table'),
        'Table'[ID] <= EARLIER('Table'[ID])
    )
)

     

    Final output

    Best regards,

    Albert He

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly