I need to create a calculated field on sharepoint 2010 that also uses 2 criteria in it's formula. I need to find the Max Date of a list of items where the Code is the same and the Year is the same.
The first 3 rows below would be grouped and the max date of 2/5/2017 would be returned in the calculated field and the last 2 rows would be grouped and the max date of 9/1/2017 would be returned.
Code Year Date
AIS 2016 1/20/2016
AIS 2016 12/15/2016
AIS 2016 2/5/2017
AIS 2017 7/5/2017
AIS 2017 9/1/2017
I'm also using InfoPath so perhaps a repeating table could be leveraged? I don't know how though.
Does anyone know how this could be done?