SAP Knowledge Base Article - Public

2642888 - How to Export a Pivot Table to Excel - Online Report Designer


How do I export a Pivot Table in ORD to Excel?


  • SAP SuccessFactors Workforce Analytics 
  • Online Report Designer


After creating a pivot query, it is possible to export the the pivot table by following the steps below:

  1. Access the component and run the pivot query:

    pv 1.jpg

  2. Go to the sheet icon and download the Pivot Table:

pv q 2.jpg

Please note that output for a pivot query will be exported in a new tab in xls format and options like xls, xlsx, csv doesn't show up for exporting pivot output similar to list report component.

Even while scheduling pivot report through Report Distributor tool csv option will not be available, same is true while scheduling report through report center.


Pivot Table, ORD, WFA, Report, Distributor, Schedule, xls, xlsx, csv, List, Pivot , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , How To


SAP SuccessFactors Workforce Analytics all versions