Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
Create a calculated dimension:
=if(Data ='NIL',text(Data),Data)
Then sort in Test -- A to Z
Br,
KC
Here is the attachment.
Thanks..
use dual function to solve
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)
select descending or Asc as per your requirement also
Hi,
Create a calculated dimension:
=if(Data ='NIL',text(Data),Data)
Then sort in Test -- A to Z
Br,
KC
Br,
KC