Activity Forums Salesforce® Discussions Is it possible to make a cross filter report of Products? Reply To: Is it possible to make a cross filter report of Products?

  • Akash

    Member
    March 22, 2016 at 2:49 pm

    Yes Brian you are right that opportunity line item is not available in custom report type but if you want to create report of Products filter by opportunity line item fields then you can follow theses steps-

    * Select report type "Opportunity with Products" and Create.
    * Select "Summary format" and create grouping with Product and then Opportuniy Product so this will show
    products with related Opportunity products.
    * Add normal filter then in the picklist you can find opportunity product fields also.

    Note- But we can not apply filter on "Number of records" of OpportunityProducts related with Product.