How to calculate in quicksight

[sagmukhe]

@Praveen - AS mentioned in my earlier post, first create those Actual, Base and Target calculated fields. Then utilizing the same create a new calculated field named achievement rate using your logic. Once that field is done, you can use that in Insight. I have already responded to a similar thread highlighting how to use such calculated field in Insight. Please refer the link below:

How to add dynamic values in a text box

Hello @suresh1 - Here you go! Hope this helps! [image] Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!