SAP Knowledge Base Article - Public

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


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


  • 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.


This is by design behavior.


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


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


SAP Analytics Cloud 1.0