View won deals by product category
Am I missing something/could somebody help me with the following please... I want to see how many of a certain product category we have sold in the last year, 2 years etc. I see a report in Insights where I can view how many of each individual product we have sold, but cannot see a way to segment by category (i.e. all the products supplied by Supplier X).
Another way I could achieve this is by setting a list view Deals filter (i.e. won deals between certain dates) and displaying the product category as a column - only those options aren't there. I can see Product Qty and Product amount only - which I find unhelpful.