Instead of creating sets ,why can't you use the logic directly in the field:
if [Sales]>=0 and [Sales]<=10000 then 'Band 0 to 10k'
ELSEIF [Sales]>=10000 and [Sales]<=20000 then 'Band 10 to 20k'
ELSEIF [Sales]>=20000 THEN 'Band over 20k'
meenu choudhary yes it could also be one the approach, but what will happen if followed my method?
also i tried with your above method also and got something like this, result - Album on Imgur which is not as per my exception. here is what i want to achieve expected - Album on Imgur . could you please suggest about this?
You can try something like this,
IF [Sales]<=10000 then 'Band <=10K'
ELSEIF <=20000 then 'Band >10K - 20K'
ELSEIF [Sales]>20000 THEN 'Band >20K'
ELSE "Null Sales"
Let us know if this help.