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.