I have seen iterations of this question in various forums but have yet to find a solution. So I thought I'd try with my specific example and see if by chance there is a solution that I've missed.
* We have Private Equity firms that we work with but they are not the contracting entity. We create Parent Accounts for each firm. (e.g. L Catterton - http://www.lcatterton.com/)
* Each PE firm has several companies in their portfolio that we actually contract directly with. Each of these companies are created as 'children' and tied back to the appropriate parent. (e.g. Cholula - http://www.lcatterton.com/Brands.html#!/current)
WHAT I NEED: One report that shows all opportunities (any stage) at all children accounts then tied to the parent company.
Here's the example that I created in Excel:
Also, is there any type of report that would show the same information as when you click on "View Hierarchy" by the Account Name in the Account Object?
Thank you, Lynette - Tulsa, OK
4 件の回答
Hi Lynette,
You can create a summary report on Child Account and Opportunities
And then Summarise report by Parent Account field on Child account.