SAP Knowledge Base Article - Public

2989452 - Accumulative sum not working with table having years in SAP Analytics Cloud

Symptom

  • Accumulative sum starts counting sum from the ALL column instead of year column

Environment

  • SAP Analytics Cloud (Enterprise) 2020

Reproducing the Issue

  1. Create a story based on a model or data source with numerical values (measures) to build a running total of the accumulated values.
  2. Create table with an account dimension in row and year period in column
  3. Right click account
  4. Click add calculation
  5. Select accumulative sum (single)
  6. Notice that accumulative sum is starting from ALL Column and that is total of all years

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

accumulative.PNG

Cause

This is the limitation of current product.

Resolution

Please submit an improvement on our customer influence portal, following the below KBA 2424376 - How to create an enhancement request for SAP Analytics Cloud

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, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, accumulative, sum, table, hierarchy , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0