In a table how to fetch the last inserted records for a dimension ?

[Chanty4u · Accepted solution]

Then create a record number field in your load script:

LOAD

     Code,

     Date,

     Value,

     RecNo() as RecNr

FROM ...;

Then, in your chart table with dimension Code, use two expressions:

=FirstSortedValue(Date, -RecNr)

=FirstSortedValue(Value, -RecNr)

[Uzumaki_N]

Thanks it worked.

[Chanty4u]

Great  . !  please accept as solution so that it will help for others.