Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Accumulate sum the Qty by individual Group

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   

1 Reply
Not applicable
Author

Any body can help me?