OBI - Pulling max item for report
I am working on a recruiting report in OBI in which the system will pull multiple rows if the data is duplicated (or, there are several pieces of information). What I would like for my report to do is select the greatest (or max) item and display only that information for that specific candidate, which may be a different item for the next candidate in the report. For example, in this report, we will display the candidate's education history. If they have multiple degrees (Associates, Bachelors, and Masters), I would like to only display the Masters degree for that candidate.