I have a workbook that I provide a filter to isolate a producer. Each producer publishes a variable number of products. The products are listed in a column, normally multiple products for each product type, but may be only one. I need to present the number of each product type in a pie chart and...