SAP Knowledge Base Article - Public

3554173 - Sorting based on dimensions in respect to multiple measures is not working on SAP Analytic Cloud (SAC).  

Symptom

Sorting based on dimensions in respect to multiple measures is not working on SAP Analytic Cloud (SAC).

 

Environment

SAP ANALYTICS CLOUD 2024.21.8

Reproducing the Issue

  1. Log on to SAC
  2. Open a story
  3. Create a chart and add multiple measures and a dimension
  4. Click on more option of chart and apply sort for dimension value.

Notice: Measure values in chart are not in sorted order.

Cause

  • This is by design behavior
  • It is not possible to sort by each of the measure value in respect to a dimension in one chart.

Resolution

Create a chart with single measure and apply sort.

See Also

Keywords

SAP Analytic Cloud, SAC, chart, calculated dimension, combination column and line chart , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0