Help with workers hierarchy in Matrix

[Anonymous]

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???

[Anonymous]

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

[Anonymous]

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