SAP Knowledge Base Article - Public

2720602 - "Cannot drop a measure into a row or column." Pivot components in Canvas / ORD Reports

Symptom

Attempting to add certain columns to the Rows / Columns in a pivot query, the following message is displayed:

"Cannot drop a measure into a row or column."

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Create a List report / query (Either with Live Data or with Advanced Reporting Data source)
  2. Create numerical calculated columns - The 'Data Type' of the calculated column must be 'Number'
  3. Create a pivot query and use the list report created in step 1 as the source for the pivot query
  4. 'Show Design View' in the pivot designer
  5. Try adding the calculated column to the ROWS or COLUMNS section

Cause

The behavior is expected for the following types of columns:

  • Numerical calculated columns (The 'Data Type' of the calculated column must be 'Number')
  • System calculated columns. Example: Direct Reports

Resolution

A workaround would be to convert the calculated column's datatype to 'Text'.

This however would limit the aggregations (Pivot Function) to the ones available for text fields only. (Concatenate, Count, etc.,)
If there is a need to use the calculated column as a row / column and use it as a numerical measure at the same time:

  • Create two versions of the calculated column with the same underlying logic
  • One should be of Data Type 'Number' and the other one should be of Data Type 'Text'
  • Use the 'Text' calculated column in ROWS / COLUNMS
  • Use the 'Number' calculated column as a Measure and perform the desired numerical aggregation (Sum, Average, Maximum, etc.,)

Keywords

Cannot drop a measure into a, row or , column, Calculated, in Pivot, COLUMNS, ORD, Canvas, Report, Live Data, Advanced, Report , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions