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
Company A
$100,000
$100,000
Company B
$56,000
$54,000
Company C
$100
$0
$0
Company D
$100
$500
$0
Company X
$100
$500
$1,000
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...
