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.
Hi as below
Data:LOAD %Sales_Key, Date, SalesFROM ...;
Inner JoinLOAD %Sales_Key,Timestamp(Max(Date)) as Date
Resident DataGroup By %Sales_Key;
View solution in original post
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....
Thank you!It's working.