How to control key figure cumulative calculation?

[former_member622272]

Hi Team,

We have created custom key figures to show values in USD currency. But unfortunately these key figures are not working as expected. for example in of the Opportunity expected value is 12,666,960.00 USD, but in report its showing as 38,000,880.00 USD. This is because expected value is showing sum of all Opp. Involved Party values.

Here is the joining condition which we used in the custom data source.joining-condition.png?

Can any one help me the solution to show Expected values against Opportunity instead of Opp. involved parties?

Thanks in advance !!

Best Regards,

Anil

cumulative-expected-value.png

expected-value-against-opp-involved-parties.png

[former_member226]

Hello,

Yes it is possible to show un-aggregated expected value against an opportunity. In order to do so define an exception aggregation based on "Opportunity UUID" as shown:

step-1.png step-2.png step-3.png

This should solve your issue.

Pls refer to: https://www.acorel.nl/2016/10/sap-hybris-cloud-for-customer-get-more-out-of-your-reports-by-counting... for more details.