SAP Knowledge Base Article - Public

3555507 - Cannot sort values in the table - SAC

Symptom

After the latest SAP Analytics Cloud (SAC) update, sorting values in the table is not possible.

The grouping of the columns to the left cannot be deactivated.

Environment

SAP Analytics Cloud 

Reproducing the Issue

  1. Open story
  2. right click on the table
  3. chose the sort options
  4. The grouping of the columns to the left cannot be deactivated

Cause

Expected behavior

Resolution

  The grouping status (Keep Left Columns Grouped, Keep Top Rows Grouped) can only be changed in the following situations: 

  • The dimension header of an inner row or column dimension is selected.
  • Ascending or descending sort has been applied.
  • Hierarchies are set to Flat Presentation.

Keywords

SAC, sorting restriction, filter, table , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0