Reporting Lines - Matrix Visual

Hello everyone. Got a bit of an interesting issue. 

I have a table that has a manager name in one column, and staff reporting to that manager in the second column. I am after a way to display this in Matrix visual so that once the manager is expanded, it shows the staff reporting to the manager. Problem is, there are examples where the staff are themselves manager of other staff. 

For example, consider the following table: 

It is giving me a result in this manner: 

Ideally, I would like Emp A to be further expanded to Emp B and then in the same row, Emp B to be expanded to their relevant staff. so that when I collapse it, Emp A should also show the sum of items for Emp B staff.