function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SmartDSmartD 

Report on Total count of Accounts that have purchased

Please help me on this.

I want to create a report on the count of account that have purchased.

 

Thanks,

Smarjit Debata

Best Answer chosen by SmartD
SmartDSmartD

I had a solution to my problem.

http://crmsuccess.blogs.com/analytics/2006/08/the_power_of_on.html

 

The solution is called "power of one". 

 

 

Thanks,

Smarjit Debata

All Answers

BharathimohanBharathimohan

Hi,

 

Create a report on Opportunitity by summarizing on Account Name.

If an Account has Opportunities with Stage as "Closed Won" and Opportunity Amount greater than zero, then the account purchased products which is the logic.

 


This report will show you the list of Accounts which has purchased, and the Opportunities that it has purchased.

 

 

Let me know if this is not satisfys your requirement.

 

Please mark this post as solved, if it helps you

 

Regards,

Bharathi

Salesforce For All

 
SmartDSmartD

Thanks Bharathi..for your quick response.

 

BTW, I need the count of account.

If I am not wrong this way I get the the total count of opportunity closed own.
SmartDSmartD

I had a solution to my problem.

http://crmsuccess.blogs.com/analytics/2006/08/the_power_of_on.html

 

The solution is called "power of one". 

 

 

Thanks,

Smarjit Debata

This was selected as the best answer