Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)":
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.