How to maintain relationship for crosstab

[MWon]

Hello all,

I've recently built out a table using the cross tab function. It currently looks like this 

Curriculum	User1	User2	User3
Curriculum1	x
Curriculum2		x
Curriculum3			x

The issue is that each user has a different manager. However, the cross tab function seems to have removed that relationship between user and the manager. This means when I try to render out separate tables for each manager, the same users stick around in the top row because the relationship was lost. 

In this case, the final render should be a separate table for each manager/users under them 

Curriculum	User1	User2
Curriculum1	x
Curriculum2		x
Curriculum3

Curriculum	User3
Curriculum1
Curriculum2
Curriculum3	x

How can I get to this point? 

Thank you in advance 

[IraWatt]

Hey @MWon,

Can you attach your workflow?

Thanks,

Ira

[MWon]

Here you go! To elaborate, in the final table here, User 1-6 are always there, when it should dynamically change depending on who their manager is