Skip to main content
Topics#FormulasPergunta de Zach Comm
Zach Comm (Arrow Electronics) perguntou em #Formulas
27 de jan. de 2017, 19:22

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 resposta
  1. Deepak R (Consultant)
    30 de jan. de 2017, 09:18
    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
Escrever uma resposta...
0/9000