Creating Pivot Table Reports

Objective

After completing this lesson, you will be able to use the Pivot Table report functionality to include data summaries in SAP Fieldglass report outputs.

Pivot Table Reports

Pivot Tables allow you to design a pivot table view for summarized report data. Pivot Table reports are created by first selecting the parent report that contains the data you want to view as a pivot table summary, then once it is ran, the output opens as an Excel file in the pivot table design view.

Screenshot of a Pivot Table report output file in Excel, with two tabs. The first one is the report tab, and the second tab called ‘pivot_report’ is open and highlighted.

Create a Pivot Table

Brian, the manager of the worker procurement program at WorkingNet Networking Inc., a manufacturer of data networking equipment, provides monthly program status updates to the Procurement team regarding open positions. While he has a variety of reports he runs that provide raw data, he wants to present the data in a more simplified and meaningful way so he and the procurement team can make business decisions around hiring.

One way he can accomplish this is by providing a Pivot Table output based on an existing report.

As the SAP Fieldglass administrator for WorkingNet, it’s your job to create the pivot table. Here’s how you’ll do it.

ExerciseStart Exercise

Summary

This lesson covers creating Pivot Table reports in SAP Fieldglass to transform existing report outputs into summarized, easily analyzable views in Excel, enabling clearer insights and better hiring decisions.

Pivot Tables create summarized views of report data for clearer analysis. They automatically add an additional tab to Excel report outputs.
Creation flow: Open parent reports run-time page and select the create pivot table option listed under Actions menu.

Next lesson