SAC Story - Calculate top N values so that it can be used in a calculation

[former_member647613]

Our scenario is as follows:

a) identify the value of sales for the top 10 customers.

b) identify value of all sales

c) calculate (a) as a percentage of (b).

We would like to use the derived value (c) in a numeric point chart.

Thank you in advance for your advice.

[Jay_Gandhi · Accepted solution]

Hi there,

Currently the limitation remains on your requirement a. You cannot show the sum of top/bottom N: https://apps.support.sap.com/sap/support/knowledge/en/2716173

Jay

[former_member647613 · Accepted solution]

So just to clarify, you are saying that SAC does not support creating a calculation which sums the top or bottom N. Thanks Marea

[Jay_Gandhi · Accepted solution]

That's correct, not with standard Story functionality.

[former_member647613 · Accepted solution]

Thanks again - is the functionality likely to become available later this year when stories and applications are combined. Are there any options using scripting at this stage (in stories). Thanks again. Marea

[mfoeken · Accepted solution]

Hi Marea,

Perhaps you can submit an improvement request through the Influence portal and share the link so we can vote!

SAP Customer Influence

Kind regards,

Martijn van Foeken | Interdobs

[Jay_Gandhi · Accepted solution]

You may want to investigate r visualizations with analytical applications as an alternative for the time being. E.g. https://www.element61.be/en/resource/sap-analytics-cloud-tips-show-remaining-sum-top-n-table-r-visua...

Jay

[former_member647613 · Accepted solution]

Thanks Jay - I was able to use the recommended link to create a table showing the top 10 and "others" and the total. My r-scripting skills are not sufficient (at present) to achieve desired nirvana which would be to simply display a table showing

Row 1 - sum of top 10

Row 2 - sum of others

Row 3 - total of row 1 and 2

Thanks for your advice. I'll keep working on that.

Absolute Nirvana might be a table that simply shows row 1.

Kind regards Marea