Insights : Product Sales Reporting by Custom Field
Currently, there is no elegant way to report on the sales value of a 'type' of product being sold, via Insights.
It's possible to build a report filtered by specific list of products, and it's possible to show the value of those products in a pie graph, but you can only select the Product field - you cannot select custom fields attached to the Product, such as 'Product Category' or 'Business Category' or the like.
It would be very handle to be able to do so, as it would allow us to show an insight on product sales mix by one of perhaps 5 or 6 categories, without having to manually filter and show each of the hundreds of individual products available.
Additionally, I note that when you report as a pie chart, the values reported for each segment correctly match the sales for that product.
However, if you select Scorecard report type, the value shown is the total value of the deals those products are attached to, inclusive of products that do not match the filtered list. So for example, the below scorecard is around $1000 higher than the pie chart above, because other products that don't match the filter list but are attached to the same deals as products that do, are included.