Skip to Content

C4C Opportunity Product Report

Can someone explain why in the Opportunity Product Report the Expected Revenue and Total Revenue values show under Product Category ID as #, Not assigned. It is important for us to review opportunity revenue by product category. Below is a screen shot of the report.

Thank you,

Gina Cowart

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 14, 2017 at 11:17 PM

    If there are opportunities with different currencies, you may see this issue.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 09:14 AM

    Please refer to the section Combined Data Sources to understand more better as in why is this shown as #

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Prasanth,

      Still this is not a proper way for the representation of Opportunity Pipeline by Product .

      How we can give our customers a proper report showing the Pipeline break down by their Products? Something like the report Sales by Product Category (Top 10) - Current Year but with Sales By Products instead of Product Categories!

      KR,

      A.

  • Jun 16, 2017 at 06:08 AM

    Hi Gina Cowart,

    The standard data source "Opportunity Header and Item" itself is a combined data source. So, this is expected behavior. However, you can try creating your own custom join data source by using Opportunity Header and Opportunity Item data sources as join members. You can try creating a report on it as per your requirement. This does not use the union concept of combined data source. Hence the extra line will be eliminated.

    You can refer to this case document while creating "2366796 - Best Practices for Modelling Data Sources and Reports - Performance".

    Regards,

    Trivedhi

    Add comment
    10|10000 characters needed characters exceeded