Sorting problem

[israrkhan]

Hi Guys:

i have one dimension in my straight table and many expressions.

what i want to do, i want to sort my dimension in any way, but want to keep my "Region"  in first row,

for example i have dimension values, as BELOW.

ABD

DEF

Region

RBG

SSS

and so....

how to sort , so Region must be at first..

Many Thanks in advance....

Regards

Khan

[luciancotea]

In the "Sort" tab, use "Sort by expression" and add

=if( MyDimension = 'Region', 1, 2)

[Gysbert_Wassenaar]

See this blog post: Establishing a Sort Order

[#4 · Accepted solution]

see attachement

[israrkhan]

no attachment is there....

[jagan]

Hi Usman,

In the script itself use dual function to specify the sort order

LOAD
     *,

     If(Dimension= 'Region', Dual(Dimension, 1), Dual(Dimension, 2) AS Dimension

FROM DataSource;

Now in sort tab specify Numeric as sort type.

Hope this helps you.

Regards,

Jagan.

[israrkhan]

Thanks to all you guys....