SAP Knowledge Base Article - Public

3068353 - Stacked Chart won't sort on total in SAP Analytics Cloud (SAC)


When creating a stacked chart with multiple stacked dimensions, the sorting is done based on the largest "slice" in the stack instead of on the total value of all the slices in a stack.   This issue only occurs when using BW as a datasource - it does not happen when using Hana.




  • SAP Analytics Cloud (Enterprise) 2021

Reproducing the Issue

  1. Create a new story based on a Live BW datasource
  2. Create a stacked chart with multiple dimensions
  3. Note that the sorting is done by the largest value in each stack - not by the total of the entire stack.


This behavior is by design and is a limitation of the BW backend.


A workaround is to enable the "Unbooked Data" option on the chart.


Example of chart in symptom section with Unbooked Data enabled:


See Also

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


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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0