Order by Trellis after limit rows in bar chart
My question is related to this request: https://dojo.domo.com/t5/Card-Building/Limiting-Pivot-Values/td-p/48031 which get a good solution from @jaeW_at_Onyx .
But my further question is that I want to show the data in a bar chart instead of a mega table. I put the suppliers' name on the y-axis ( it is cal 2 shown on screenshot) and put the supplier bucket as a trellis (it is cal 1 shown on screenshot). Then I use the rank function on the blue value in the beast mode to get the rank calculated field and sort it to get the top 20 suppliers. But I could not put all ranked suppliers that belong to the same bucket together. In the below ss, it is only ordered by the blue value instead of by cal 1 and blue value.
Here is an example of what I could get now:
Does anyone have any suggestions on this?