Skip to main content
Topics#FormulasZach Comm's Question
Zach Comm (Arrow Electronics) asked in #Formulas
Jan 27, 2017, 7:22 PM

Identify Largest Non-Grand Summary Value in Matrix Report

I'm using a matrix report grouped by Case Owner. The summary at the end of the rows is the total number of Cases each Owner has closed. I would like to automatically identify the number of Cases that the person who's closed the most Cases has closed. I.e. if different reps close 4, 6, and 8 Cases each, then I want the formula to return 8. The reason I need this inside the report itself is because this number will then be used in the formula to calculate each Case Owner's performance according to a curve based on said number. Is this doable without code? If I need to code to find it, how can I?
1 answer
  1. Deepak R (Consultant)
    Jan 30, 2017, 9:18 AM
    Hi Zach,

    You can try creating a custom report type : Users with Cases.

    Create a new report of this type and use group by filter to get the cases per User and set the field filter to "closed=true".

    Here you can use conditional highlighting to achieve what you want.

    Hope it helps.

    RD
Write an answer...
0/9000