7 Replies Latest reply: Nov 17, 2017 2:10 PM by Vishwarath Nagaraju RSS

    Need help in sorting the value in descending order

    Bharath Vikas Shanagonda

      Hi All,

       

      Thank you for helping me in some of the question which I posted earlier. I've a new requirement in our project where we need to sort the values from highest to low. Below tables tells you in detail of what I'm getting and what I would like to see.

       

      I've a table which has device information and some columns with expression as 'SUM' and below is the table which I'm getting.

       

      DeviceHigh CountMedium CountLow Count
      A244
      B422
      C655
      D466
      E112
      F435

       

       

      I would like to see some thing like below.

       

      DeviceHigh CountMedium CountLow Count
      C666
      D455
      F445
      B434
      A222
      E112

       

       

      The difference between the two tables are it is sorting the High, Medium and Low from Highest to Lowest and here 'Device' is my column name and High count is 'SUM(HIGH'), Medium Count is 'SUM(MEDIUM)' and Low Count is 'SUM(LOW)' and I'm using Pivot table in my app.

       

      Regards,

      Vikas