Unable to sort by measure in bar chart with multiple dimensions, how can I add top N to this set analysis

[datagrrl]

I would prefer to sort by the measure value, but that does not seem to be an option when using multiple dimensions.

How can I filter this by the top 20 (for this example).

Sum(
{<CustomerID = {"=Count(DISTINCT Make) > 1"}>} SalesPrice
)

My use case is that I want to see the total sales price for customers who have more than one of the selected makes.

I have attached my demo app. The chart I am using is on the Question 0225 sheet.

[morgankejerhag · Accepted solution]

You can sort by expression on the dimension. I added your measure as a master measure and referenced it in sorting.

[datagrrl]

Thanks. I forgot I could do it that way.