Hi Nandhakumar, could you please post an example .twbx or some data ?
My initial thoughts are to do a max() calculated field, but this will depend on your data structure.
Please find the attached file in the original conversation.
Thanks & Regards,
How does this look ?
I created a calculated field to sort the medals, with a bit of internal ranking to ensure that Gold beats Silver, beats Bronze in the event of a tie.
Medal_Tally.twbx 68.0 KB