10 Replies Latest reply on Aug 19, 2016 7:47 AM by Andrew Watson

    Sorting Dimensions by Calculated Fields That Use Table Calculations

    Sam Fleisher

      Hi,

       

      I have a table calculation that I'd like to sort by.  Its essentially sorting employee names by the fill rate of their sessions.  I tried using the zn() and it didnt work.  If I right click on employee names, hit sort, the fill rate field isnt available (I assume because it's a table calc).  Is there any other workaround, e.g., LOD or rank?

       

      The fill rate calc is :

      zn(window_sum(sum([reservations]))/window_sum(sum([Capacity])))

       

      Thanks!