Symptom
When exporting a pivot table to excel, the cell format is always text.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Create a Pivot table in Canvas report
- Export in Excel
- Fields are in text format
Cause
This is working as designed.
Resolution
It is expected that the cell format in the exported excel file from a pivot table is text. So, e.g., if you export a pivot table where you used a date field, it will in text format by default:
Keywords
Pivot, export, text, format, date field, field, cell, cell format, excel, xls, xlsx, canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To
Product
SAP SuccessFactors HCM Suite all versions