How can I fetch only the latest records?

[Ankit1911]

Hi Everyone,

I have the following fields in the table, with the single or multiple records for each of the %Sales_Key.

I want the latest record for each of %sales_key; There have been multiple sales reported for each %Sales Key;
But Need to fetch the latest one at the script level Like below :

Thank you for your help.

[BrunPierre · Accepted solution]

Hi as below

Data:
LOAD %Sales_Key,
Date,
Sales
FROM ...;

Inner Join
LOAD %Sales_Key,
Timestamp(Max(Date)) as Date

Resident Data
Group By %Sales_Key;

[Tanish]

Hi Ankit, 

Let me tell you the simplest way to achieve this result.

Create a Table 

1. Add Dimension - %Sales_Key

2. Add Measure - Max(Date)

3. Add Sales as Dimension not measure.

You will get your result....

Thanks,

Tanish 

[Ankit1911]

Thank you!
It's working.