5 Replies Latest reply: Jul 24, 2012 5:25 AM by Heather Butters RSS

    How to Return single row with maximum value

      Hi,

       

      I have a chart table in which I want to show only students who are currently interrupted in their study. Each student has a number of terms they are registered in, and they may be either registered or interrupted in any one of them. I already have an indicator of whether student is currently interrupted, however I want to show as a dimension the term in which they are currently interrupted. Some students may have been interrupted multiple times over their history but I want to only show the latest interrupted term details. I attach a qvw with simple sample data and a table which is currently bringing back every row that the student has been interrupted in when I want it to show the maximum term row.

       

      Can anyone help. I presume it requires some degree of aggregation in the set analysis but I can't get it right.