6 Replies Latest reply: Sep 14, 2017 4:36 AM by divya anand RSS

    Show all rows with highest value of FieldB w.r.t each FieldA

    divya anand

      Hi,

       

      The data table is as shown below and I am trying to create a table with rows which has only top value of "altB" for each category  -

      I could achieve till this, i.e., find the top values of "altB" with respect to each category-

      I am stuck here, how do I show all rows where category & altB are as shown in the above table? The table I am looking for should look like this-

       

      PFA a sample app. I am trying to solve this without any changes to be made on the datamodel/script.