SAP Knowledge Base Article - Public

2906725 - Can sorting be applied to measures and dimensions together in one chart in SAP Analytics Cloud (SAC)?

Symptom

Sorting applied to dimensions will be removed if adding sort to measure in a chart in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Login to SAC.
  2. Create a story with chart in it.
  3. Select the chart and apply sort to one dimension.
  4. Then apply sort to one measure.
  5. The sorting applied to dimension is removed.

Cause

This is by design behavior.

Resolution

Sorting data can be applied on multiple dimensions, but cannot be applied on dimensions and measures together, and we can only sort on one measure at a time.

Details in Help guide below:
Sorting Measures and Dimensions

See Also

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, chart, data, sort, sorting, order, dimension, measure, dimensions, measures, pie, column, charts, chart, missing, remove, removed, lost, BW, table, order , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0