Filter the record with maximum date from a set of records- straight table

[alknirmal1]

Hi,

I have a straight table as shown in the screenshot where I  have multiple records for a specific case number.

I need to show only the case number with the maximum timestamp (Date Key ID) .

Is there a way to do this in the straight table?

e.g For the case number "1" I want to show only the record with the Date key id 4/2/2020

I appreciate your help on this.

Attached the QVW file for your reference.

Thanks

Nirmal

[Durgadevikumar · Accepted solution]

Hi Nirmal,

Good Day😊

Create the one calculated dimension to show the maximum date  records alone,

= aggr(max(Date Key ID),Case Num)  // find the maximum date  group by case number

So, now case number with maximum date records only populated in the straight table other records are eliminated.

Hope it is useful

Regards,

DurgadeviKumar