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

    Sorting a measure.

    Venkatesh A



      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.