How to show only the MAX response attempt for a questionniare response in OTBI analysis

Summary:

We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to present the final input (last attempt) in a summarized report. I cannot find a way to filter the analysis output on the maximum response attempt only

Content (required):

I have an analysis with a single subject area: Workforce Management – Checklist Real Time

Trying to use MAX("Checklist Questionnaire"."Response Attempt Number") but system seems to 'randomly select' what it returns as the Maximum value

It is important to our organization to keep this analysis in OTBI.