I have a sharepoint list that records/tracks peoples monthly or quarterly submissions. Each record includes items like:
- First Name
- Last Name
- Date
- City
- State
- Sum of Transactions
These records can be submitted monthly or quarterly, so there are a ton of records with the same names. I am filtering the gallery by combo box, dropdown, and text search and I have a sold field dropdown:
SortbyColumns(
Filter(
Search(
)))
All of this works perfectly. What I would like to add is a way to only show the most recent record, by name and within the last 3 months. My hope is to be able create personal gallery. For example: If I filter by state, I would only see one record of each person that has made a submission in the last 3 months. Where as now it will show every record that has that state... I don't think the Distinct( function would work but maybe the First( in combination with a hard coded filter of the date of submission being <= 90 days.
Any help would be appreciated.
525
