SAP Knowledge Base Article - Public

2493771 - How to Create Pivot Tables - Report Canvas

Symptom

  • How to Create a Pivot Query in ORD?
  • How to Create a Pivot Table?

Environment

  • SAP SuccessFactors Workforce Analytics (ANA) - All versions
  • SAP SuccessFactors HCM Suite
  • Report Canvas
  • Advance Reporting
  • Detailed Reporting

Resolution

This section describes how to create a pivot table from a List Report.

  1. To Pivot a list of data, go to Tools Pivot Query Designer
  2. Decide what you want to measure (drag into the white area of the workspace).
  3. Decide how you want to pivot the data, for example, Sum, Count, Average, Minimum, or Maximum.
  4. Slice the data by adding fields onto the columns and rows
  5. Use the Show Design View to edit the Measures, Columns, and Rows
  6. When finished, save your pivot so that you can add it into a Pivot Table or Chart component in your report.
  7. To lay out the Pivot on the page, add a Pivot Component, then attach the saved pivot query.

a) Go to Tables Published Data Table , and add the table component to the page.
b) Right click and choose Edit this component.
c) Select the desired query.

  1. Finally, format your pivot table by adjusting the table style, labels, and layout.
  2. Screenshots can be found in the reference link.

See Also

Keywords

Pivot Query Table Online Report Designer ORD Advance Reporting How to Create Pivot Query , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions