2674881 - Is Column Sorting option available in Pivot Query or Chart? - Report Canvas

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

SAP SuccessFactors HCM Suite

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

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

Sorting will be applied to pivot tables based on the first field selected in the Rows section.

If the first field is a date column, it will be sorted by earlies to latest based on that field. If it is a string column, it will be sorted from A-Z.

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