SAP Knowledge Base Article - Public

2720602 - "Cannot drop a measure into a row or column." - Calculated columns in Pivot query

Symptom

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

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

Environment

SuccessFactors Pivot Reports

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 with Numerical calculated columns.

Numerical calculated columns (The 'Data Type' of the calculated column must be 'Number') cannot be used as Rows or as columns in pivot reports.
They can only be used as measures.

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 Column in Pivot 
ROWS 
COLUMNS
ORD
Report Canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core all versions