I have a field of Patrollers, they are using a form to enter interactions with customers. In my sheet I have been able to create a summary report that counts the various Interactions by Patroller breaking out (Guest Assist, Violation, Slow Zone), cant get the sheet to Sort my count... But what I am looking for, and it would i guess be in the Sheet Summary, is the Partroller who is currently leading?
So if Joe has 10 Violations (the most Violations), I want 'joe" to display, but if Nancy issues more violations and passes Joe, I want "Nancy" to display.
Any ideas?
