SAP Knowledge Base Article - Public

2674881 - How does Column sorting option work in Pivot Query - Online Report Designer


How does Column sorting option work in a pivot query in ORD?

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


SuccessFactors Workforce Analytics (ANA) - All versions


The Column sorting option is only available in the List Report query.

sort query.png

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

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


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


Column sort sorting order option list pivot query table ORD online report designer , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , How To


SAP SuccessFactors Workforce Analytics all versions