Symptom
Is it possible to add measures to the columns or rows on a pivot query?
Environment
- SAP SuccessFactors HXM Suite
- Report Canvas
Resolution
It is not possible to add measures into the rows or columns. This happens because the field type is a numeric value.
Workaround:
Create a calculated column, convert the numeric field to a string, and add this calculated column to the rows or columns section.
Keywords
2418819 - Reports Best Practices & Restrictions for Ad Hoc - ORD (Online and Offline capabilities), rows, columns, Pivot, query, Measures, Numeric, String , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem
Product
SAP SuccessFactors HCM Suite all versions