A.3.7 Using Pivot

Pivot reports transpose rows into columns to generate results in a cross-tab format.

Select pivot columns and rows and then provide the functions to be represented in the pivot report. Once created, pivot reports display a new icon on the search bar.

To create the pivot, follow these steps:

1. Click Actions menu and select Pivot. The Pivot page is displayed.
2. Select / Enter the fields as described in the following table

   Table A-3 Pivot - Fields and Descriptions

   Field	Description
   Pivot Column	Select the Pivot column from the drop-down list.
   Add Pivot Column	Click Add Pivot Column to add another pivot column.
   Row Column	Select the Row Column from the drop-down list.
   Add Row Column	Click Add Row Column to add another Row column.
   Functions	Select the Function from the drop-down list.
   Column	Select the column from the drop-down list.
   Label	Enter the label of the column.
   Format Mask	Select the Format Mask from the drop-down list.
   Sum	Move the toggle button to the right to enable the Sum option.
   Add Function	Click Add Function to add another function.

3. Click Apply. The Pivot page is displayed.
   The Search bar now contains View Report and View Pivot icons. Click these icons to toggle between report and pivot views.