Have you got a sample dataset or a twbx to provide us?
Below is the data for reference. Under "MGR Name" Santhosh" level 1 Manager and Ruth and Samantha are Level 2 Managers.
When I need count of associates under santhosh, i have to get 6, when i need count of associates for Ruth and Samantha, it has to 1 and 2.
I need Manager level wise count of associates.
We have only 2 fields "MGR Name: and "Associate Name". If we select Santhos in MGR Name i will see 3 names under associate Name as dinesh, ruth and Samantha, When i select Ruth as "MGR NAme" then i can see Madhav under Associate Name.
I think i have given you data in detail.
MGR Name Associate Name Associate Name Santhosh Dinesh - Santhosh RUTH Madhav Santhosh SAMANTHA Santa SAMANTHA Anjali