31 Replies Latest reply: Feb 21, 2017 4:35 AM by Nagarjuna Vattikuti RSS

    How to sort items based on spend and i need figures based on savings in the pie-chart

    Nagarjuna Vattikuti

      How to sort items based on spend and i need figures based on savings in the pie-chart.I want to sort only top 3 items and  this is my table


       

      Item ID SpendSavings
      1112012
      1214014
      139040
      143016
      1518018
      166030
      1711017
      18408
      1913025
      2016010

       

       

      So pie-chart answer should be like this                                          and NOT like this

       

      Item ID      Savings                                                                 Item ID      Savings

      15                18                                                                          13             40

      20                10                                                                          16             30

      12                14                                                                          19             25

       

       

       

       

      Thanks in advance

      Regards

      Nagarjuna