Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

Configure Opportunity Split Revenues for a team

(0) ShareShare
ReportReport
Posted on by 899

Hello,

Assuming that a team owns an opportunity that consists of 3 members.

We would like to split the revenue between these sales team members to measure their performance when working on an opportunity together.

I am aware that the Opportunity split is not available by default and we need to create that custom entity.

https://learn.microsoft.com/en-us/dynamics365/sales/configure-forecast-using-custom-rollup-entity#opportunity-split

So, for each opportunity, a sales manager should manually split the revenue across those members by going to that custom table and later on configure a forecast based on that.

What about if we set a goal for this sales member and the opportunity is won? Will the targeted amount be updated under goals management based on the revenue amount specified under the opportunity split? If so, what query do we need to set up for the goals between opportunity and opportunity split?

Can this approach be considered the most effective way to achieve the opportunity split process? Can you please provide a small example of the goal management query?

Any help is greatly appreciated.

Best regards,
EBMRay

  • Suggested answer
    Sayen Zhang Profile Picture
    on at
    RE: Configure Opportunity Split Revenues for a team

    Hi EBMRay,

    Here is a link about split revenue over members of a sales team when an opportunity is won: How to split revenue over members of a sales team when an opportunity is won - Microsoft Dynamics CRM Forum Community Forum

    Hope this link will help you!

    Best Regards,

    Sayen Zhang

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 671 Super User 2025 Season 1

#2
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 167 Super User 2025 Season 1

#3
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 138 Most Valuable Professional

Product updates

Dynamics 365 release plans