The following is a tip on how to show how often a product is being added to an opportunity. It involves create a rollup field that counts the number of related opportunities. Once you have this variable it is easy to include into charts, reports and views.
- Customize the system
- Navigate to Product > Fields
- Add new rollup field
- Click Edit
- Add the Related Entity and Set Aggregation to Count
- Save and Close
- Then Save and Close
- Add this column to a View
- Publish All Customizations
To test this out, create an opportunity add a Product. Then manually trigger the recalculation of the Number Opportunities attribute by adding this attribute to the Product form and then clicking the recalculate symbol.