I want to sum the quantity field we have on a sales order but only if the color of the item is a specific color. For example, 6 widgets were sold on a SO; three are red and three are white. I would like to create two columns showing how many red and how many white were sold across the company. The color is a custom field on the item and also stamped on the SO.
Thank you!