2 Replies Latest reply on Dec 17, 2015 12:58 PM by Mikey Michaels

    Top N, Bottom N

    Mikey Michaels

      Friends,

       

      I have a calculated field (Seats UM diff) in a table that calculates the difference between two time periods. I need to filter this field in by TOP 10 and Bottom 10 for each "Selected over Text" change . I tried creating an INDEX function to start, however I'm having a hard time getting the INDEX function to restart after every "Selected Over Text" change.

       

      Any ideas on how to help?

      Cheers,

      Mikey