5 Replies Latest reply on May 10, 2016 9:14 AM by HUNG TRAN

    Help on Calculated Field

    HUNG TRAN

      Hello,

       

      I have my data as below:

       

      TYPE           SIZE           QTY

      Coffee          A                10

                          B                7

      Espr             A                6

                          B                9

                          C                9

      Herb             A               11

                           B               2

                           C               5

      Tea                A               8

                            C               6

       

      I want the result as below: (MAX of QTY of each TYPE)

       

      TYPE           SIZE           QTY

      Coffee          A                10

      Espr             A                 6

                          B                 9

      Herb            A                 11

      Tea              A                 8

       

       

      How do I create a calculated field the display a result as above? Thank you very much!