By default, a Pivot Table groups the selected column as the vertical sort field and the selected row as the horizontal sort field. The Pivot Tool enables you to select multiple group fields in the Pivot Table generated.
Pivot Tables reorganize and summarize selected columns and rows of data in order to obtain a desired report. For more information, see Viewing Data in a Pivot Table.
The Pivot Tool contains a list of columns available in the active report and Group By, Across, and Measure sort fields. Drag the columns into the desired sort field.
The Pivot Tool opens, as shown in the following image.
A column must be included for the Group By and Measure sort fields (Measures typically define how much or how many). The Across sort field is optional.
In the example below, CATEGORY and RATING are the Group By sort field, COPIES is the Across sort field, and WHOLESALEPR is the Measure field.
You cannot use multiple Measures.
The Pivot Table is generated based on the sort fields selected. You can click the New icon from the Pivot Table and select Pivot Tool to open the Pivot Tool again.
The following apply when you use the Pivot Tool in active reports: