Pivot Table

You can use the Pivot table function to create a report in the form of a standard Microsoft Excel pivot table, into which you can import current data from the backend system as required.

You define a pivot table by specifying the characteristic values and the location within the pivot table. You can use the Pivot table function to define the basic layout of a pivot table. After you have created the pivot table, you can still interactively rearrange data in the table at any time by using the standard Microsoft Excel pivot table functions to present data in different layouts.

Prerequisites

You have installed Microsoft Excel 2010 or later and the Interactive Excel component provided by SAP.
A temporary folder with write permission must be available for current user in which an auxiliary database for the pivot data needs to be created.
You have opened a workbook that uses the Interactive Excel template.

Features

Interactive Structuring of Reports

Pivot table reports have a very flexible layout. Characteristics are inserted into the sheet in the form of field buttons that you can drag between the header, rows, and columns, as required. For information, see the Microsoft Excel documentation for pivot tables at http://www.microsoft.com.

Specification of Characteristic Values

You can enter the following categories of characteristics in a pivot table:

Single value
Selected characteristic values are used in the pivot table definition.
Set list
All characteristic values from the selected sets are used in the pivot table definition.
Hierarchy
All branches from the selected hierarchies are used in the pivot table definition.

Location of a Characteristic in a Table

Row/column layout
The selected characteristic values are displayed in the row column of the pivot table. You can change their position as required.
Header data
The selected characteristics are valid globally for the whole pivot table.
Constant
Data is used similar to header data, but the value is hidden, that is, it is not displayed in the worksheet.

Specification of Debit/Credit Sign Logic

The debit/credit sign logic is the same logic as the logic for data matrix. For information, see Debit/Credit Sign Logic.

Caution Caution

Use the sign logic of values with caution. Pivot tables can sum up characteristic values on their own (standard feature of Microsoft Excel). When sign logic is used, sums can be inevitably incorrect.

End of the caution.

Note Note

You can create a pivot chart in Microsoft Excel 2010 by selecting Pivot chart and then Type of chart.

End of the note.