I have a pivot table with revenue calculations based on weeks ago. An example is pictured below:
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...