Hi @AmitCoastr - Welcome to AWS QuickSight community and thanks for posting the question. If you have one report which will contain all data, then you can use RLS which will filter the data w.r.t users. Please see the RLS details in the link - Using row-level security (RLS) with user-based rules to restrict access to a dataset - Amazon QuickSight
We have a monthly Q&A Session of QuickSight today, Please register and we can discuss more on this requirement as well. Please find the link below.
Regards - Sanjeeb