Latest dimension record in plain table

[#1]

Hi all,

I need to show a table with just dimension values. Therefore I use a plain table with just dimensions, no expressions.

I wonder if it's possible to customizie the plain table thus, that just the latest VERSION for each STATUS is shown.

I know that this could handled by just loading thus records, but unfortunately they are needed othwerise.

Example attached.

Best regards

Thomas

[sujeetsingh]

Try using calculated dimension for Version and then put in the logic to determine the latest one.

[Nicole-Smith · Accepted solution]

Where you dimension is version, change it to a calculated dimension and use:

=aggr(maxstring(VERSION),TPLNR,DOKAR,DOSTX,STATUS)

Your fixed file is also attached.