SAP Knowledge Base Article - Public

2783539 - BIRT Reporting - How to perform a Transpose (Rows to Columns) in Ad Hoc / Table reports


Performing a Transpose (Rows to Columns) is not possible with the in-built reporting tools alone.
It is however possible with BIRT Reporting.

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 HCM Suite


The attached presentation - BIRT_Transpose provides the basic steps to build a transpose template in BIRT that can then be uploaded to Ad Hoc / Table Reports.


  • The guide is provided only as a convenience.
  • Support is predominately focused on system malfunctions or bugs rather than providing consulting to our customers.
    In principle, consulting issues or how to requests are dealt with on our Community Area on the Support Portal or handled by a member of the Professional Services team.
  • Customer requests such as designing reports, dashboards or tiles are not handled by SAP Cloud Support.
  • In case there is a requirement to create a custom report/tile it is possible to contact the professional services as per KBA 2149831.

See Also

How to Create a BIRT Template for an Ad Hoc report

Support Guidelines for Ad Hoc Reports with BIRT Templates


BIRT, transpose, ad, hoc, report, table, rows, columns, change, convert , KBA , LOD-SF-ANA-BIR , BIRT Reports , How To


SAP SuccessFactors HXM Suite all versions