Ifelse query statement

Hello @Siddhi_21, you can also try making alterations to the calculated field suggestion I made. This is a good chance to learn about the calculations and look at the documentation that I am linking.

My initial guess is that the spelling of the field in the calculation I wrote is slightly different to the actual field name in your dataset. Instead of using copy and paste, try typing out the suggestion and selecting the autofill options that QuickSight provides as you type the solution. Thank you!