So if one person ordered 2 of an item, one person ordered 10 of an item, and one person ordered 5, it's showing up as 3 because 3 people ordered it. Am I doing something wrong or can I fix the report?
All I want is a list of each item and the Total Quantity of that item that were ordered between whatever dates I put in or from whatever order statuses I choose. So in the above example, if those orders were in Processing, then I'd want the report to show 117 for that item.
Does that make sense? Please help.

UPDATE:
OK, disregard the above post as I found the report was setup wrong and was using the field QUantity instead of the Metric:Sum Quantity. I changed that and it's happy now.
However, I still have one issue. I don't see a way to pull the Brand/Manufacturer of the product into the report. I can pull the category but not the brand. Is there some way to add that in? I need to run the report and sort it by supplier so I can submit my order to them to be fulfilled.
One other thing, is there a way to do an OR filter? Can I do filter Order Status is Processing OR Order Status is Processed? I see I can add two separate lines but assume that is an AND and not an OR...
Thanks.