AnsweredAssumed Answered

Portal filter for unique recored by latest date

Question asked by lightawave on Jan 18, 2018
Latest reply on Jan 19, 2018 by beverly

I am trying to filter my data to show only unique records with their latest dates

 

let's say this is a table I have.

productdatesome extra text
apple1-1-2017text 1
apple4-4-2018text 2
banana2-2-2012text 3
banana5-5-2013text 4

 

 

And I want to end up with a portal only showing this.

 

productdatesome extra text
apple4-4-2018text 2
banana5-5-2013text 4

 

 

Is this possible and how do I accomplish this?

Outcomes