Creating Pivot Table Reports

Objective

After completing this lesson, you will be able to create a Pivot Table.

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.

Log in to track your progress & complete quizzes