Hi Vaibhav @Vaibhav.narwade ,
If Giridhar’s suggestion worked for you, please mark it as solution. If you are still having problems, please create a sample analysis in Arena with mock data and include link to it along with clear explanation on the numbers you expect to see for various data filter combinations. This will help the community take a better stab at solving your problem.
Regards,
Arun Santhosh
Pr QuickSight SA