I'm sure there is a simple answer for this, that I'm overlooking. When reviewing something with one of our Sales Reps she brought up that a sizable opportunity in her pipeline report is actually a split opportunity between her and 2 other people (50/25/25 split); however the full opportunity amount is showing on the report vs only the 25% she is credited for. It is a standard Opportunity report (not a split opportunity report). I'd like to be able to see split and regular opportunities on reports for our reps. I haven't been able to figure out how to build out a report that will show me both. I've tried Cross Filter logic on a standard Opportunity report, but it won't let me have an "or" statement. I also tried creating a custom Report Type (opp - master (A), opp split - child (B)) but it wouldn't show me either or either. If anyone can lead me in the right direction that would be awesome. Thank you! @Opportunity Split
Michael Brown (Salesforce) Forum Ambassador
Hi Michelle,
You should be able to just use the standard Opportunity Splits report type for this. For example, when I do this, I just see the split information:
There are a few key notes:
- Make sure to include the Amount from the Split object, and not the Opportunity Amount in your report columns
- Make sure to include a filter for Active splits only. It sounds like there is a default split created, in which you might see a split for the total opportunity amount, which was likely created by default once splits were enabled
Thanks,
Mikey