3 Replies Latest reply: Nov 16, 2015 4:11 AM by jagan mohan rao appala RSS

    Help on -> getting the correct value through grouping or set analysis?

    Teck Rul Saw

      ITEM

      COMPANYBRANDON-HAND-QTYCTN
      item2comp1A2010
      item3comp1A455
      item4comp1A7015
      item1comp1A3020
      item1comp2A2520

       

      Above is the current result & the below is the excel file.

       

      ITEMCOMPANYCTN
      item1comp112
      item1comp220
      item2comp110
      item3comp15
      item4comp115

       

       

      I wanted to make the result to become something like this...

       

      Header 1Header 2Header 3Header 4Header 5
      item1comp1A3012
      item1comp2A2520

       

      I have try,

      Max({<QUANTITY_UM={"CTN"}, ITEM, COMPANY>}CONVERSION_QTY)

       

      //sum(if (QUANTITY_UM='CTN', CONVERSION_QTY, 0) )

       

      //if (QUANTITY_UM='CTN', Sum(CONVERSION_QTY), 0)

       

      but the result is not what I want. Please help.