Display one active record

[#1]

Hi All,

I need to know if there is an option to display one record from a list of active rows/fields in expression similar to script (where RowNo()<1) which gives one record from the uploaded data.

Thanks,

Sai.

[jagan]

Hi,

In script you need to derive a new column like below

LOAD

RecNo() AS RecordNumber,

*

FROM DataSource;

Now in Straight table just give dimensions you require and give below expression

=Only({<RecordNumber={'$(=Min(RecordNumber))'}>} RecordNumber)

Hope this helps you.

Regards,

Jagan.

[anbu1984]

Expr: If(RowNo() = 1,Field)

If you want to display latest row within a group based on date, then you can use Firstsortedvalue()

Expr: Firstsortedvalue(Field,-date)

If this is not helping you, can you provide sample input and expected output