Duplicate Purchase Orders

[gfisch13]

Hello all,

I'm working with a file of purchase orders where I have all the line items for the purchase order, but each line one has the gross total of the Purchase Order.

I want to get to a situation where I have one purchase order and the total amount.

This is what I see:

PO ID               Desc          Total

12345          pencils               500.00

12345          pens                  500.00

12345          garbage bags     500.00

65478          tickets               200.00

78963          computers          800.00

78963          software             800.00

This is what I want:

12345                            500.00

65478                              200.00

78963                              800.00

Any help is appreciated!!!

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(Amount, [PO ID]))

or

Sum(Aggr(Only(Amount), [PO ID]))

or

Sum(Aggr(Avg(Amount), [PO ID]))

or

Sum(Aggr(Sum(DISTINCT Amount), [PO ID]))

[gfisch13]

Perfect, THANKS!!!!