3 Replies Latest reply on Oct 28, 2018 6:39 AM by A Je

    Parameter using a rank calculation

    A Je

      I am attempting to identify the top N employees by avg duration in seconds in each year..

       

      The Top N employees can be different every year.

       

      I used a rank calculation to facilitate the identification of employees and now I want to use a parameter to pull the top employees.

       

      A simple Top N filter parameter does not appear to work b/c it takes the aggregate of all seconds over all 4 years and then shows them for each year (all of the employees are the same when I look at the years).

       

      What parameter can I use to select the Top N employees.

       

      Please see attached image.

       

      Please see the attached work book and provide the required parameter

       

      Message was edited by: A Je I added a workbook so that the parameter could be provided in the workbook. I appreciate all of your assistance.