Accum total by...

velo85

New Member
Is it posible to display sum of all orders by Item No. by Customer No.

Accumulate quantity (total by item no. by Customer No.)

Display Accum total by item No. by customer No. (quantity).

I need to get total of sold items group by each customer and each item.


If you understand me, please help. :):):):):)
 

Osborne

Active Member
Do you mean something like this?:
Code:
FOR EACH Order NO-LOCK,
   EACH OrderLine NO-LOCK WHERE OrderLine.Ordernum = Order.Ordernum
   BREAK BY Order.CustNum BY OrderLine.Itemnum:
   ACCUMULATE OrderLine.Qty (TOTAL BY Order.CustNum BY OrderLine.Itemnum).
   IF LAST-OF(OrderLine.Itemnum) THEN
      DISPLAY Order.CustNum OrderLine.Itemnum
              ACCUM TOTAL BY OrderLine.Itemnum OrderLine.Qty
              COLUMN-LABEL "Item Total".
   IF LAST-OF(Order.CustNum) THEN
      DISPLAY Order.CustNum ACCUM TOTAL BY Order.CustNum
              OrderLine.Qty COLUMN-LABEL "Customer Total".
END.
 

velo85

New Member
Thx Osborne.
I have one table orders with 3 columns:

CustNo. ItemNo. ItemQTY.
1000 600 50
2000 500 45
3000 600 50
1000 600 50
2000 500 50
1000 500 30


what i need is to calculate for customers in total how much items they order.

Somthing like this
CustNo. ItemNo. ItemQTY
1000 600 100
1000 500 75
2000 500 95

This example from osborn gives mi for customer total of all items for one customer, but i need total for each diferent ItemNo. for evry Customer.
 
Last edited:

Osborne

Active Member
The example - will run against the Sports2000 database - does give totals for each different item number for each customer and also a total of all items for the customer.

To only have a total for each different item number for every customer remove these lines:
Code:
   IF LAST-OF(Order.CustNum) THEN
      DISPLAY Order.CustNum ACCUM TOTAL BY Order.CustNum
              OrderLine.Qty COLUMN-LABEL "Customer Total".
 
Top