Forum Discussion
Sort by sum
Hi BI_now ,
You want the "Verkauf QM" column to be sorted in descending order like this and the months are sorted starting from January, right?
It's impossible, the value of "Verkauf QM" corresponding to each month is fixed.
So you either sort the "Verkauf QM" in descending order or sort the month.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Xue Ding.
But in your example your lowest data is in january the highest is december.
When you sort "Verkauf QM" descending the december is at the top. But the month must be in the correct order january, february,...
I tried it with month number in the data again but it's still not working.
BUT what is working now is when I sort it with "KundeNummer" and "KundeAnschrift", ascending and descending, the months are in the correct order jan, feb, mar, and so on.
When I sort "Verkauf QM" it's the same problem like before, descending the best month is at the top.
Hi BI_now ,
You want the "Verkauf QM" column to be sorted in descending order like this and the months are sorted starting from January, right?
It's impossible, the value of "Verkauf QM" corresponding to each month is fixed.
So you either sort the "Verkauf QM" in descending order or sort the month.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I want to sort by sum of the customers (70009, 70014,... -> there are more than 300 customers)
-> The sum is 10.622.261,13 for 70009 then 6.605.161,42 for 700014 and so on.
But the month "inside" this customer has to be in the correct order Jan, Feb, Mar...