Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
see attachement
In the "Sort" tab, use "Sort by expression" and add
=if( MyDimension = 'Region', 1, 2)
See this blog post: Establishing a Sort Order
see attachement
no attachment is there....
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.
Thanks to all you guys....