Skip to main content
Topics#Reports & DashboardsZach Comm의 질문
Zach Comm (Arrow Electronics) 님이 #Reports & Dashboards에 질문했습니다
2017년 1월 26일 오전 12:58

How is it possible to identify the largest non-grand summary integer in a matrix report?

Reps are measured on a curve determined by the performance of the highest performing rep. Performance is determined by cases closed. On a matrix report which uses a column grouping for each agent, how can I find the number of cases closed by the highest performing rep?
답변 2개
  1. Zach Comm (Arrow Electronics)
    2017년 1월 26일 오후 2:55
    Yup, Case Owner is the grouping. The reason I'm trying to automatically find the highest row summary is to use that as the basis for the curve, i.e. multiplying it by, say 0.8 and then dividing each other agent's row summary into that to produce a percentage of the curve reached. For example, Agent A does 20 cases, the curve for that is 16. So when Agent B does 8 cases, their score is 50%. I know I can achieve all of this with a formula -except- the identification of the highest row summary. If I use the MAX function, the value returned is the grand summary, and that's not what I'm trying to pull.

     

    Yup, Case Owner is the grouping. The reason I'm trying to automatically find the highest row summary is to use that as the basis for the curve, i.e. multiplying it by, say 0.
답변을 작성하세요...
0/9000