4 Replies Latest reply on Sep 25, 2015 9:02 AM by Joanne Zhou

    Averaging over clients' last scores

    Joanne Zhou

      Hi,

      I am trying to get the average of all the last scores of each ID within a certain time period.

      I am able to label the "Last" record for each client, and show only the last record and get the average.  Then I realized that the grand total reflected all scores not just the last scores.

      Does anyone have a quick solution?  I really appreciate!

      Thanks

      Joanne

       

      My sample case is attached.