Click on this link for the poll.
Formula for Quantity of Products Sold in Single Record Return
Hi, hoping someone with SQL can help. Our sales staff sell a couple of widgets blue and red. I want to run a search which pulls all our sales orders and presents the total sum quantity of blue widgets and the total sum quantity red widgets sold against each sales order as a single line item record with a field for each item.
eg: SO Id, Sales Person, Total Red Widgets, Total Blue Widgets
I can run a search to show any sales orders with these items, but it creates a line for each item, so for a sales order where both red and blue were sold, we get two returns.