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

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

datagrrl — Thu, 27 Feb 2025 16:01:34 GMT

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 — Thu, 27 Feb 2025 16:43:52 GMT

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

datagrrl — Thu, 27 Feb 2025 20:33:21 GMT

Thanks. I forgot I could do it that way.