Reverse the Ranking Order

Amanda Jeske

I am working on ranking clients based on revenue with the highest revenue being number 1. In the end I want to build a top 25 list that could change on any given day based on new data. I used this formula to rank my items: =RANKEQ([Lost Client-SUM-BI Estimated Annual Revenue]@row, [Lost Client-SUM-BI Estimated Annual Revenue]:[Lost Client-SUM-BI Estimated Annual Revenue], 1)

The issue is it is backwards for me. I need the largest revenue client to be ranked #1. I tried doing some digging on this and didn't find an answer that would work for me. Anyone have thoughts on how to reverse the ranking order?

The sum of revenue data is being created by a pivot table.

Paul Newcome

Have you tried a zero in place of the one at the end?

Paul Newcome

Have you tried a zero in place of the one at the end?

Amanda Jeske

Thanks, Paul. That did work. Such an easy fix! I appreciate your help

Paul Newcome

Happy to help. 👍️