Hi experts,
I am a beginner with reports in C4C. I am having some trouble with result row.
I have the characteristics Opportunity,Distributor,
Distributor contact and Expected value as a key figure in a report.
In case a Distributor is having multiple contacts, I will have multiple rows for a single opportunity with each having Expected value.So when I find out the result row,all of these values are added.So an incorrect result is shown.
Following is the screenshot.

In the above report,for Opportunity "test Opp with Comp", it is having 6 rows due to multiple distributor contacts and thereby having 6 values for "Expected value" key figure . And the sum of Expected value is shown as 127,272.00USD instead of showing
21,212.00 USD.
Can anyone please suggest me a way to handle this so that only one expected value is considered for each opportunity irrespective of the number of distributor contacts, while calculating the result row.
I tried out something with Exception Aggregation,but couldn't find a solution.
Thanks in advance,
Vishnu