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

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

• SAP SuccessFactors HXM Suite
• Report Canvas

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.

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