SAP Knowledge Base Article - Public

2932385 - Not able to select Break Grouping after enable show totals in a table when sorting in SAP Analytics Cloud (SAC)

Symptom

Not able to select Break Grouping after enable show totals in a table when sorting in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.11.2

Reproducing the Issue

  1. Logon to SAC tenant and create a new story on a sample imported model.
  2. Insert a new table to the story.
  3. Add several dimensions and measures to the table.
  4. Right click the title of the measure > Sort Options > select Sort Descending.
  5. Find it's possible to select Break Grouping after applying sorting.
  6. Enable show totals for one dimension.
  7. Then it's not possible to select Break Grouping as per following screenshot:

Cause

This behavior is by design.

  • Breaking the grouping with totals on the rows would break the sorting and lead to a messed up state of the values

Resolution

Please raise up this enhancement request to SAP customer influence site:

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, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0