Hi @Ganga,
There’s a bit to this question in regards to working with calculated fields and testing out; perhaps it may be easier if you are able to upload your analysis with sample dataset to the QuickSight Arena so that we can test out some potential options. Are you able to do that?
Thank you