5 Replies Latest reply on Oct 9, 2013 1:21 PM by Julia Hennelly

    How to set up a Top N with a calculated rolling 3 month percentage

    Julia Hennelly

      I thought this would be really straightforward but it does not seem to be so and hence I am guessing I am missing something obvious.  I have a list of departments with their turnover percentages (based on a rolling 3 month headcount).  I need to at least be able to sort descending with the department with the highest turnover at the top.  What I really want to do is show a Top N.  I am attaching my workbook which is very simple.  I thought that if the user clicked on the sort button next to turnover percent they would see the departments sorted in descending order by turnover. I also do not see the calculated field as a sort option?

       

      Any ideas?

       

      Julia

      worksheetview.JPG

      topnsort.bmp