1 Reply Latest reply: Mar 13, 2012 9:12 PM by Kelven NG RSS

    How to Accumulate sum the Qty by individual Group

    Kelven NG

      How to sum all the qty group by supplier

      Example i have Supplier, ItemGroup, Item and Qty, and i would like to accumulate sum all the Qty base on individual Group

       

       

      Supplier     ItemGroup     Item          Qty          AccuItem      AccuItemGroup            AccuSupplier

      Man               A               A1            10               10                 10                                10

                                            A1             20               30                 40                                30

                                            A1             30               60                100                               60

                                            A2             20               20                 120                              80

                            B              B1             10              10                  10                                90

                                            B2             30              30                   40                               120

                                            B2             10              40                   80                               130

                            C              C1             10              10                   10                               140

                                            C2             10              10                    20                              150

                                            C3              20             20                    40                              170

       

       

      Please some one help me. Many Thank