topic Re: Sorting based on dimension and measure in App Development

Sorting based on dimension and measure

WhatsUp — Mon, 23 Sep 2024 09:52:22 GMT

Hi guys,

I got the following task:

I work with a pivot table. In the pivottable I have multiple rows like so: Date | Customer_ID | Text

As KPI I use count(number). I want to order the pivottable by date and afterwards it should order based on the count(number) so that I see the highest number for each date. As far as I tried I could only sort either by date or by the KPI but not both. Could someone help me out?

Re: Sorting based on dimension and measure

justISO — Mon, 23 Sep 2024 10:53:53 GMT

Hi, try modify sorting properties from Auto to Custom and set 'Date' field sort numerically, and 'Customer' field set to be sorted by expression "count(number)":

Re: Sorting based on dimension and measure

WhatsUp — Mon, 23 Sep 2024 11:36:45 GMT

Thanks for the reply.

Unfortunately it doesn't work. I have the Date and Customer_ID. On the rows and the count(sales) in the KPI section. When sorting the date like you descriped it works. But the count(sales) isn't sorted.