9 Replies Latest reply on Jun 12, 2018 3:01 PM by Numerouno A

    Top 'N' Rank across Date and 2 Dimensions

    Numerouno A

      Hi Friends!

       

       

      Not sure if my requirement is a unique one but i really need your help. i  tried to look for possible solution in forums but couldn't find it. i need to calculate a dynamic rank across 3 different dimensions ( For a Date,Departure city and  Issue Type) and the user wants the rank to be dynamic where they can punch in Top 'X'.

       

      Attaching a copy of my work book with mock up data for you reference.

       

      Really Appreciate if you can help me this.

       

      Thanks,

      GS