Summarising Data

[scottappleford]

Hi

I am trying to summarise how much of a product i have in stock but it keeps returning every line item that have been transacted.

e,g 400 have been ordered in 5 transaction but rather than it list the item once and tell me how many are in stock it gives every transaction so say nails list 5 times instead of once with the total in stock.

thanks for your help

scott