Ranking/Sorting with 2 Dimensions

I have a pivot table visual of period sales grouped by Supplier and Product. I need my sales values sorted first by supplier in descending order and then by product in descending order within each supplier. How can i do this?

My sales measure for reference being summed in the table is:

ifelse(in(DepletionMonth, ${P1DateInt}), Dollars, 0)

Hi @dspringer and welcome to the QuickSight community!
Take a look at this article regarding the sorting in pivot tables. Let me know if this assists with what you’re trying to accomplish.
If this does not help solve your solution, please provide a screenshot of your visual if possible so that I can see how you have the table setup.

Thank you!

1 Like

Hi @dspringer ,

The doc page @Brett linked in his response shows you how to accomplish what you were trying to do. So, marking Brett’s response as the solution here. Please do let us know if you have further questions.

Regards,
Arun Santhosh
Pr QuickSight SA