Rowno() from bottom to top

[Anonymous]

hello,

i want to have the rownumbers from bottom to top to know the latest data.

¿is there any way to do it?

thank you

pd:i have also a column of unique date as yyyymm  if that can help.

[Kushal_Chawda · Accepted solution]

try below

Data:

LOAD *

FROM Table:

DataSort:

noconcatenate

LOAD *,

          Rowno() as RowNo

resident Data

order by Date desc;

drop table Data;

[Anonymous]

hi

Yes You can have By using chart

The rownumbers from bottom to top to know the latest data By Using

On RowNumber

Chart--> Sort Tab --> Numeric Value --> Descending Order

Regards

Tahemas Momin