Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is my Dimenssion
I want to sort my data with this dimenssion
=if(Aggr(sum(Gross_Sales),Year,Customer)<0,'Negative Sale',
if(Aggr(sum(Gross_Sales),Year,Customer)=0,'0 Sale',
if((Aggr(sum(Gross_Sales),Year,Customer)>0 and Aggr(sum(Gross_Sales),Year,Customer)<=500),'1-500',
if((Aggr(sum(Gross_Sales),Year,Customer)>500 and Aggr(sum(Gross_Sales),Year,Customer)<=1000),'501-1000',
if((Aggr(sum(Gross_Sales),Year,Customer)>1000 and Aggr(sum(Gross_Sales),Year,Customer)<=3000),'1001-3000',
if((Aggr(sum(Gross_Sales),Year,Customer)>3000 and Aggr(sum(Gross_Sales),Year,Customer)<=5000),'3001-5000',
if((Aggr(sum(Gross_Sales),Year,Customer)>5000 and Aggr(sum(Gross_Sales),Year,Customer)<=10000),'5001-10000',
if((Aggr(sum(Gross_Sales),Year,Customer)>10000 and Aggr(sum(Gross_Sales),Year,Customer)<=30000),'10001-30000',
if((Aggr(sum(Gross_Sales),Year,Customer)>30000 and Aggr(sum(Gross_Sales),Year,Customer)<=50000),'30001-50000',
if((Aggr(sum(Gross_Sales),Year,Customer)>50000 and Aggr(sum(Gross_Sales),Year,Customer)<=100000),'50001-100000',
if((Aggr(sum(Gross_Sales),Year,Customer)>100000 and Aggr(sum(Gross_Sales),Year,Customer)<=500000),'100001-500000',
if(Aggr(sum(Gross_Sales),Year,Customer)>500000,'500000+'
))))))))))))
Unselected actual chech and select Load Order
currently, as it stands, it is ordering you alphabetically by the result of the dimension
Still it is not working.It is disable still
So what can i do for sorting
you can write in Expression:
=ValueList('Negative Sale', '0 Sale', '1-500', ....)
=ValueList('Negative Sale', '0 Sale', '1-500','501-1000','1001-3000','3001-5000')
it also not working.
not even changing anything
you can write the expression of the dimension but with a number in front.
1. Negative Sale
2. 0 Sale
3. 1-500
...
in order to sort by alfatec text
Thanks its working but it will be great if you share with me how can i remove the 1. 2. 3. in my front view
Review the following Design Blog post:
Regards,
Brett