Show data by hierarchy of Leader

Screenshot 2023-05-14 at 7.48.27 PM

As shown in above image I have leaders listed, here leader 1>leader 2> leader 3> leader 4 is hierarchy of priority of their ownership. I want to showcase the table such that for every leader, I should show only below leaders under him?

for example,
for leader abc, i should show all leaders
for leader sham, i should show kanna(also below leader ‘cgsdfg’) and mama(his below leader ‘dfg’).

In my use-case their are many leaders and corresponding data consolidated beside the leaders, how do I show by entering dynamic username in search box?

Hi @nitishpala I believe you are looking for cascading filters.

1 Like