2354859 - Is it possible set a column header for a Pivot Query / Table Component?

No row headers or labels are displayed for the Pivot table / query component in Report - Canvas.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HXM Suite

1. In Canvas, create a new report page and add a pivot table component.
2. Note that the columns have no headers or labels.

This is an expected system behavior.

Working as Designed.

The first link on "Reference" tab has an explanation from Product Management regarding this function and a possible workaround for the headers (use of text tokens).

Note: It is not possible to export the text token in Excel. As workaround you can export the Canvas report in PDF format.

As another workaround option, you can also change the "Title" of the report to the columns name.

To do that, please follow the instructions below:

• Go to the affected report and edit it
• Click on the "Menu" option next to the query
• You will see the "Title" that will be displayed when you export this report. 
• Change this title to the respective columns that you would like to display when exporting the report. 
  
  Note: It will not be displayed as separated columns in the Excel file. It will be displayed as a Title, serving as a reference to read the report data accordingly. 

Please use Story reporting Type where you can view this.

Pivot, table, query, row, headers, column, headings, field, labels, ORD, report, component, Canvas, center, Online, Designer , KBA , missing header , report missing header , LOD-SF-ANA-ORD , Online Report Designer , Problem