SAP Knowledge Base Article - Public

2674881 - How does Column sorting option work in Pivot Query or Chart - Report Canvas

Symptom

  • How does Column sorting option work in a Pivot query or Chart in ORD?
  • Is it possible to change the sort order on a Pivot or Chart?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HXM Suite

Resolution

The Column sorting option is only available in the List Report query, it is not available for Pivot or Chart queries.

sort query.png

Even if you sort the columns inside the query, it's not going to affect the pivot or chart query.

The pivot query has ascending order in rows and columns and it's not possible to modify.

pivot.png

You can submit an enhancement request in our community 2090228 - How to submit enhancement requests

Keywords

Column sort sorting order option list pivot query chart table ORD online report designer , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Suite all versions