2 Replies Latest reply on Feb 23, 2016 2:58 PM by Ravi Munukutla

    Sort by rank based on a recent date

    Ravi Munukutla

      Hi,

       

      I'm trending market share for each product in the portfolio by day. I want products to be sorted based on their rank. Rank is determined based on market share for the most recent period. In the below picture, P2 has the highest share on Jan 10th. So, I want P2 to be the first column, P1 to be second column and P3 the third. Wondering how I could do this. Even if P2 does not have the highest rank for subsequent periods, I want it to be at the top because it has highest rank for the most recent date.

       

      Appreciate your time and attention!

       

       

       

       

      Thanks!