3 Replies Latest reply on May 8, 2016 6:53 AM by Ashish Chaudhari

    Sorting a measure.

    Venkatesh A

      Hello,

       

      Please consider the example from the "Sample Super Store" data source.

       

      I have created a "Calculated Field" that ranks the running average of the sum of the sales:

       

      RANK(RUNNING_AVG(SUM([Sales] ) ) )

       

      Now, i created a text table with "Country" Vs "Rank". When i try to sort the rank either in ascending or descending order, sometimes there is some mismatch in arranging the sequence of numbers. How can i correct this?

       

      Kindly check the attached snapshot.

       

      Also, attached the workbook.

       

      Sorting.jpgThanks