I have a pivot table with revenue calculations based on weeks ago. An example is pictured below:
|Supplier||Last Week Revenue||-2 Weeks Revenue||-3 Weeks Revenue|
Currently I have the table only sorting by Last Week Revenue but in the event of a tie, I need the next best performer. I need an expression to sort this first by Last Week Revenue, then by -2 Weeks Revenue, then by -3 Weeks Revenue.
So in the event of a tie, the sorting will be by the next measure. In this example, I would need the sorting to be...
Anything helps. Thanks!