Forum Discussion
Hierachical rollup
hierachyI need to go from this: Phone UserID ManagerID Cost (111) 111-1111 1 $ 21.00 (111) 111-1112 2 1 $ 25.00 (111) 111-1113 3 1 $ 24.00 (111) 111-1114 ...
- Anonymous - Have you tried the pattern found at https://www.daxpatterns.com/parent-child-hierarchies/ ? You'll likely want to reference your data table keeping only [UserID] & [ManagerID] to make your 'hierarchyTable'. I mocked up a file for you however my reply message no longer shows any features like adding attachments or pictures , etc.
Thanks I will give it a try :) Looks promising!
ChrisMendoza
Resident Rockstar
Resident RockstarAnonymous - Have you tried the pattern found at https://www.daxpatterns.com/parent-child-hierarchies/ ? You'll likely want to reference your data table keeping only [UserID] & [ManagerID] to make your 'hierarchyTable'. I mocked up a file for you however my reply message no longer shows any features like adding attachments or pictures , etc.
Thanks I will give it a try :) Looks promising!
v-chuncz-msftCommunity Support
Anonymous,
By the way, you may share the solution here once it is solved. Your contribution is highly appreciated.
This solution worked great. Key thing is to ensure all the managers are indeed users and the top manager (CEO) does not have a manager.
Stephen