Sai- Without looking at how your data is structured, have you tried "All Values in Hierarchy", "Only Relevant Values" options when filtering?
Yes I have tried using both the options and I am still facing the same issue.
Example, consider the below Table: If I filter on the Supervisor say "Egor", I want all employees that report to him directly and also the employees who report to his immediate report.
Employee Name Supervisor Adam David Bryan David Charlie David David Smith Smith Egor Alex Smith
Sai- This kind of recursive hierarchy is something new to me, fortunately not new to the forums. So I have found few threads and workarounds for this kind of problem. Here are the links,
Some useful links,
Hope you find these useful.