Range Sorting

[mulan1]

I

I am trying to build a bar chart with a range, in Alternate State.
Dimension: SubField( Class(aggr(Sales,Invoice IS),250),'x',2 )
Measures: {[Group A]}Invoices , {[Group B]}Invoices
(Invoices is a measure as well)

its working fine, the problem is in the sorting. as you see its off : 1000 before 750, 0 in the middle ...
now i am sorting by my Dimension (
( SubField(Class(aggr(Sales,Invoice IS),250),'x',2 ) )

I tryed several aproches in vaid.
many tnx in addvenced

[ckarras22 · Accepted solution]

I think something like 

num#(purgechar(SubField(Class(aggr(Sales,Invoice IS),250),'x',2 ),'<'))

in your Dimension sorting expression should work 

[mulan1 · Accepted solution]

it worked with num instead of num#.

thank you very much