Recent 10 Events by Date and Contains

Courtney Caswell

I am working on a report to show the last 10 items that have been completed with a criteria. I saw on another post that they recommended having a helper column that will check if it was the recent but didn't have an example.

I am looking to do this,

[Recent 10 ABC]=1, if [Final Date]=recent 10 and [Location] contains ABC

Paul Newcome

Ok. Try something like this...

=IF(AND(Location@row = "ABC", [Final Date]@row >= LARGE([Final Date]:[Final Date], 10)), 1)

Paul Newcome

Are you looking for help setting up the helper column or generating the report after the helper column has been set up?

Courtney Caswell

@Paul Newcome I would like help setting up the helper column. I think I can figure out the report after the fact and just do it based on the checked box.

Paul Newcome

Ok. So what exactly are your criteria for the checkbox column then?

Courtney Caswell

@Paul Newcome If column [Location] contains ABC, and the last 10 (most recent) dates from [Final Date]

Essentially I have to make this twice one for ABC and one helper column for CBA as they each are different reports.

Paul Newcome

Ok. Try something like this...

=IF(AND(Location@row = "ABC", [Final Date]@row >= LARGE([Final Date]:[Final Date], 10)), 1)