This Forum post will explain how to build a report which shows the value of Products held within Opportunities and their Opportunities respective stage.

To begin with create a new prepopulated report based on Opportunities (Start > New > Report > Select 'A new prepopulated report' > Opportunities).

This will display a report with a number of predefined columns.

To view the Product information you will need to drill through to the line item level. To show the products listed on each Opportunity select 'Add Column' > Line Items > Product.

A column to show the amount for each line item is also needed as this will drive the summary view. To do this select 'Add Column' > Line Items > Net (home currency).

Next, add a Summary View from Details.

To show the value of each product and their respective Opportunities stage add a Split Column. For column, select 'Line Item Net' and split by 'Opportunity Stage'. Next, choose to group by 'Product'.

The report should then look similar to the example below.

If you are interested in a particular product you can apply a filter to view this information.