Dears,

I am new to Zoho Analytics and I would like to ask you guys help to creating a ranking column.

Report type: Pivot

Matter: I want to create a ranking column on the right of Percentage. This ranking is group by column Type, and ranking by Final Score/Percent.

E.g.: With the below image:
+ Group External area: there is only 1 row, should be rank 1

+ Group Office: All rows have the same value, then all rows should be rank 1

+ Group Production: rows with 100% then Rank 1, rows with 99.4% should be rank 2.

Thank you in advance!