1 Reply Latest reply on Jan 19, 2018 11:57 AM by Norbert Maijoor

    Display only MAX value based on multiple criteria

    Andrew Schuman

      I have a set of data that I'm looking to find who a customer is helped by most frequently across the locations. I'm able to get counts of encounters but I want to filter out all but the highest count for each customer. Ex. John Doe is helped by Jane Smith 4 times at the office on 1st St and 3 times by Bob Jones at the office on Park Ave. I only want the display to return the 4 visits with Jane Smith. Does anyone know of a way to do this?