sorting data

[Bharathi09]

Hi All,

I have a straight table in that I have dimension with name 'STATUS' in that 10 columns are there for nine columns the status shown as 'Connected Successfully' and one column shown as 'Failed'

How to show that 'Failed' status at top?

[vinieme12]

you can add a custom sorting order during data load

dummy:

Load * inline [

STATUS,so_Status

Failed,1

Connected Successfully,2

];

Then use Sort by Expression for the Dimension STATUS 

=Max(so_Status)

OR add the below  Sort by Expression without creating a new sort order field

=Wildmatch(STATUS,'Failed','Connected Succesfully')

values will be sorted in the order you add values to the wildmatch() function  ASC