Retreive latest records in Webi Reports

[former_member609055]

Hello ,

we have a requirement in webi reports to only retrieve the records with latest purchase date without sorting on data.

Meaning, the order in which records are displayed will not be altered. It will display in the same sequence it is read.

I am new to WEBI not sure how to achieve this

Thanks in advance!

[amitrathi239 · Accepted solution]

use below variable to show only latest record for each customer.Filter on table where equal to "Show"

V Show/Hide=if([Purchase Date]) = Max([Purchase Date]) in ([Customer]) then "Show" else "Hide"

[former_member198519]

As I understand you need the latest date in a calendar month. If yes, you need to create an additional formula to get the months first

[Month]= Month([Purchase Date])

then you need to have another formula to filter the dates and set the filter to 1

= if([Purchase Date] = Max([Purchase Date] in ([Month]))) then 1 else 0

[former_member609055]

Thank you both,

It works😀