SAP Knowledge Base Article - Public

2342441 - Sort Column Not Behaving as Expected in an Adhoc Report - SuccessFactors


  • Sort Column functionality in Adhoc is not working correctly
  • Data in Adhoc report is getting sorted in reverse manner than what is selected

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 HXM Suite

Reproducing the Issue

  1. Go to Adhoc Report
  2. Sort the report using Sort Column functionality under Columns tab, i.e. sort report on columns Country and Degree (both ascending):


  1. Preview the report and notice the data is not getting sorted correctly for Degree column, instead of ascending it is sorted in descending order:



Check if the column which is not getting sorted in correct manner is a picklist column or not. If yes, then check the below steps:

  1. Sorting functionality for picklist columns in Adhoc sort data based on the Picklist Option ids and not the Labels
  2. Go to Admin Center > Picklist Management > download the Picklist (Not the order of the Option Id and the Labels)


In order to confirm the above mentioned cause in Adhoc, change the configuration of the column to show the Picklist Option Id instead of Label.:

  1. Go to Configuration Tab in Adhoc and click Show Value ID configuration
  2. Check the Show Value ID configuration in front of the column name
  3. Preview the report. Notice the report is getting sorted correctly on the basis of Option Id
  4. See the Picklist Labels in the Adhoc report get sorted based on the Option id. (Label with less Option id will display first in the report when sorted in ascending order)



  • To sort Labels correctly in Adhoc, change the order of the Labels in Picklist and arrange them according to the Picklist Option Id order
  • If Option id is in ascending order, put the labels in ascending order and vice versa


SF, success factors, ANA, RPT, ad hoc, PLT, platform, picklist, pick list, ID, Table, Center, ascending, descending, incorrect order , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To


SAP SuccessFactors HCM all versions ; SAP SuccessFactors Workforce Analytics all versions