SAP Knowledge Base Article - Public

2920150 - Is it possible to add measures to the columns or rows on a pivot query?

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