- How to Create a Pivot Query in Canvas reports?
- How to Create a Pivot Table?
- SAP SuccessFactors HXM Suite
- Report Canvas
- Advance Reporting
- Detailed Reporting
This section describes how to create a pivot table from a List Report.
- To Pivot a list of data, go to Tools Pivot Query Designer
- Decide what you want to measure (drag into the white area of the workspace).
- Decide how you want to pivot the data, for example, Sum, Count, Average, Minimum, or Maximum.
- Slice the data by adding fields onto the columns and rows
- Use the Show Design View to edit the Measures, Columns, and Rows
- When finished, save your pivot so that you can add it into a Pivot Table or Chart component in your report.
- 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.
- Finally, format your pivot table by adjusting the table style, labels, and layout.
- Screenshots can be found in the reference link.
Pivot Query Table Online Report Designer ORD Advance Reporting How to Create Pivot Query , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To
SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions