Is it possible to add the value of all sales to a customer if they have ever bought product X ?

Question

I want to get the Lifetime Value of a Customer who has purchased Brand X.  Each sale is an opportunity. Currently I have a report that gives me the total value of this customers purchases of Brand X but how do I include the other brands also. I do not want to include customers who have not purchased Brand X

Jeff May · Accepted Answer

If you are using Accounts,  Opportunities, and Products, you can create a rollup summary field on the Account that SUMs Opportunities.  You might need to create rollup summary fields on Opportunity to COUNT or SUM OppLineItems for a specific Product.

Is it possible to add the value of all sales to a customer if they have ever bought product X ?

Reports & Dashboards

Related Learning

More Help