2 Replies Latest reply on Jul 4, 2018 3:30 AM by Aung Myat

    Sorting based on number of counts and level of details

    Aung Myat

      Hi Experts,

      I have having some issue with sorting the columns.

      I have two dimensions ( Match and Score) and one measure value score_count (%).

      I created a sheet as shown in the snap shot

      I want to sort the Score based of score_count(%) for each match (i.e. higher per cent to lower per cent for each match).

      How could I do that?

       

      The second thing that I want to do is to keep only three highest % score for each match.

       

      I have attached the workbook too.
      Your expert opinion are much appreciated.
      ThaksAung