Hi @HimaniS,
Apologies for the delayed response from the community on this thread. Trying to work through some ideas on this but I don’t have a great sample dataset that’s similar to run some testing on;
This may be easier to assist further if you are able to upload a sample dataset to the QuickSight Arena view: