custom sort on an expression listbox

[#1]

Hi All,

I have a listbox based on an expression like the following :

=if(aggr(sum(Amount),CustomerCode)<50, '<50', if(aggr(sum(Amount),CustomerCode)<500, '50-500', if(aggr(sum(Amount),CustomerCode)>500, '>500')))

The listbox is working but I have 2 problems :

1) I cant sort by the good order :

• <50
• 50-500
• >500

2) when I select a value from this listbox, the 2 non selected values disappear.

Do you know how to solve these issues pls ?

Regards

[maxgro]

1)

use dual

dual('<50',1)   instead of <50

dual('50-500',2)

....

and sort by number

[JonnyPoole · Accepted solution]

For

#2) add a set modifier to cancel out the CustomerCode selection:

=if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<50, '<50', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<500, '50-500', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)>500, '>500')))

[#4]

thank you, works fine