Hi there,
I'm not sure what's the best method to obtain a running total but any working method would be great. I've seen many examples but none for exactly what I need.
I have a table that has the first 3 columns with data. I'd like to calculate the 4th column, which is a running total of order qty for the part, regardless of the order #.
I need to retain the arrival sequence of the records (or sorted by order #, part #). My attempts at this seem to reorder the data by part # or I get a total order qty and not running total.
Thank you.
Glenn Gundermann
I'm not sure what's the best method to obtain a running total but any working method would be great. I've seen many examples but none for exactly what I need.
I have a table that has the first 3 columns with data. I'd like to calculate the 4th column, which is a running total of order qty for the part, regardless of the order #.
I need to retain the arrival sequence of the records (or sorted by order #, part #). My attempts at this seem to reorder the data by part # or I get a total order qty and not running total.
Order # | Part # | Order Qty | Running Total of Order Qty for Part |
11111 | AAAAA | 1 | 1 |
11111 | BBBBB | 2 | 2 |
11111 | CCCCC | 3 | 3 |
22222 | BBBBB | 4 | 6 |
22222 | CCCCC | 5 | 8 |
33333 | AAAAA | 6 | 7 |
Glenn Gundermann
Comment