Products Purchased

Share

Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.

Problem

As an Account Manager in order to identify white space on Accounts, I would like to see a list of Opportunity Products purchased on each Account.

Solution

In order to see the results on an Account, a hierarchy rollup must be created.  Products are first rolled up to the Opportunity, then again to Account.

Step 1) Create a text area field on Opportunity (Products Purchased) and a text area field on Account (Opportunity Products Purchased)

Step 2) Create a rollup of Products Purchased to Opportunity:

  1. Rollup Helper tab, select Opportunity
  2. Select the field you created (Products Purchased)
  3. Select Opportunity Product as the Child Object and Product ID > as the field, then Product Name.
  4. Select Text (Separated by New Line)
  5. Save and Run the rollup

Step 3) Create a hierarchy rollup to Account:

  1. Rollup Helper tab, select Account
  2. Select the field you created (Opportunity Products Purchased)
  3. Select Opportunity as the Child Object and Products Purchased (rollup results) as the field
  4. Select Text (Separated by New Line)
  5. Add a filter for Closed Won Opportunities - Stage Contains Won (WHERE isDeleted = false AND stagename LIKE '%Won%' ORDER BY Id DESC NULLS LAST)
  6. Save and Run the rollup

 

 Need help?
Schedule a one-on-one demo

USE CASE: Generating a Unique Count of Records Rollup Helper Use Case Library Number of Calls or Emails on an Opportunity