Sort order issue

[nareshthavidishetty]

Hi,

I have a issue with sort order.I have tried all sorting items but not working.

Please find the attached spreadsheet for detail and required output.

Thanks..

[nareshthavidishetty]

Here is the attachment.

Thanks..

[manoranjan_d]

use dual function to solve

[manoranjan_d]

LOAD [Actual data],

RecNo() as num

FROM

xxx

create list box and in the sort tab select the expression and give

Dual([Actual data],num)

[manoranjan_d]

select descending or Asc as per your requirement also

[jyothish8807 · Accepted solution]

Hi,

Create a calculated dimension:

=if(Data ='NIL',text(Data),Data)

Then sort in Test -- A to Z

Br,

KC

[jyothish8807]

Br,

KC