Skip to main content
We're trying to create a report that shows any Opportunities with a specific Opportunity Product and all of the Activities associated with the Opporutnity.  The best I could come up with was a Joined Report with one block for Opportunities with Products filtered by the Product Name, and the second block for Opportunities with Activities.  However, this brings back too much data still.  Is there a way to filter the report further so that it does not show rows with 0 records in the first block, or sort it by the Product Name in the first block so that all of my Products come to the top of the report?  Joined Reports - Sorting by Value or Removing Rows with 0 Records?

 

 
2 risposte
  1. 13 feb 2017, 18:28
    @Diana: You can try this way, In the first block you can Summarize a certain field. There you can filter by removing the ones with zeroes

     

    @Diana: You can try this way, In the first block you can Summarize a certain field.

     

    User-added image

     

     
0/9000