Hello everyone,
I have a coloumn with a lot of numbers and as an example i have uploaded a screenshot of it.

I wanted to classify them into groups so i wrote a case when like this :

CASE

        WHEN KPI("max_potential_saving") BETWEEN 7000 AND 70000  THEN 1  

        WHEN KPI("max_potential_saving") BETWEEN 1000 AND 7000  THEN 2      

        WHEN KPI("max_potential_saving") BETWEEN 800 AND 1000  THEN 3    

        WHEN KPI("max_potential_saving") BETWEEN  600 AND  800 THEN 4  

        WHEN KPI("max_potential_saving") BETWEEN  400 AND  600 THEN 5

        WHEN KPI("max_potential_saving") BETWEEN  200 AND  400 THEN 6

        WHEN KPI("max_potential_saving") BETWEEN  0 AND 200  THEN 7

        ELSE 8  

    END
but when i sort it based on the classification it does not show the Max Potential Saving in order from highest to lowest. Does anyone have an idea ?
 

Thanks in advance !