Issue Description:
In the attached snapshot, I need to determine the ranking for Point1A under Point2A, where the value is 48, and for Point1B under Point2A, where the value is 31.
I duplicated the same table and applied a table calculation for ranking using the RANK() function. However, the ranking is being calculated in descending order, whereas I need it to be in ascending order.
Expected Outcome:
I want the ranking to be sorted in ascending order, so the smallest value gets rank 1, rather than the highest value.
Could someone guide me on how to adjust the ranking calculation to achieve this?
To modify the RANK() function to include the ascending order, the syntax should look something like this: RANK([YourField], ['asc']) , where [YourField] is the field I am ranking.
