SAP Knowledge Base Article - Public

3392718 - Cannot arrange Totals at the bottom of a chart in SAP Analytics Cloud (SAC)

Symptom

When using “Arrange Totals” in Chart Properties in the Builder tab, "At the End" option still shows Totals at the top of the chart in Live BW Optimized Story in SAP Analytics Cloud (SAC).

Environment

SAP Analytics Cloud (Enterprise) 2023.16.10

 

Reproducing the Issue

  1. Create an Optimized Design Experience story consuming data from a Live BW Model.
  2. Add a “Bar/Column” Chart.
  3. In the Builder, select a dimension.
  4. In the Chart Properties section, find Arrange Totals.
  5. In the drop down list, select "At the End".
    ===> Notice Totals is still at the top of the chart.

Cause

This is the expected behaviour for Live BW datasources. 

Resolution

  • Currently, using the "Arrange Totals" option in Charts to move the position of the Totals when active hierarchical dimensions are enabled isn't expected to move the position of the Totals.
  • This is resolved by the "Arrange Parent Nodes" feature instead.
  • To specify the position of totals for SAP BW data sources when active dimension hierarchies are set in the chart, use the "Arrange Parent Nodes" option instead of the "Arrange Totals" option.

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.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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 epm, business intelligence,
, KBA , LOD-ANA-UNS-DSG , Unified Story Designer Issues , Product Enhancement

Product

SAP Analytics Cloud all versions