SAP Knowledge Base Article - Public

3207797 - Running Sum in a Chart appears in reverse order in SAP Analytics Cloud (SAC)

Symptom

When displaying a running sum in an SAC Chart with Time dimension on the category axis, and “Default Order” specified, the running sum may appear to be in the reverse order from what is expected.

Environment

  • SAP Analytics Cloud (Enterprise) 2022.1.10

Reproducing the Issue

Cause

For SAC charts, when the Default Order is set and Time is on the category axis, a Descending sort with a maximum number of rows is sent to show the most recent time members. Once the Chart receives the result from the back-end, the results are reversed back to the time order seen in the chart. This is expected as part of the Auto Limits feature to ensure that the chart isn't overplotting too many data-points while showing the most recent time members in a time correct order.


However, for a running sum, this results in the latest values being the lowest and the running sum in the query and when the members are reversed it to show the correct time order with the running sum reversed, leading to a sum that is in the opposite direction of what is desired.

Resolution

  1. Specify the sort on time as 'Earliest to Latest' in the Chart's Sort Menu. This ensures that Auto Limits will not send a DESC sort on Time since the chart is required to be sorted in a specific way - in this case to generate the desired running sum. 

  2. Consider using a YTD function or accumulator that is sort agnostic.

Note: This behavior was due to the Auto Limits re-ordering time data for the user on the client-side to show the most recent data. This is no longer done in Optimized View Mode or Optimized Design mode.  You may need to apply Time filters if there are a large number of data-points.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0