Using the Pivot Table Wizard

This topic uses the Last Month report (available in the Statistics report category) as an example.

  1. View a report of Pivot Table type.
    Click here to learn how to view a report    .

  2. Right-click on any data within the spreadsheet. A context menu will appear.

  3. Select Wizard.
    The Pivot Table and Pivot Chart Wizard - Step 3 of 3 will start. (It starts on step 3 because steps 1 and 2 were used when the Pivot Table was first created.)

  4. Click Layout.
    A map of the Pivot Table will appear. This shows you how each field is displayed in the Pivot Table. The white area represents the Pivot Table. The other areas represent fields that you may use in the Pivot Table.

Fields in the ROW area will appear vertically down the side of the spreadsheet.

Fields in the COLUMN area will appear horizontally across the top of the spreadsheet.

Fields in the DATA area are summarised (generally either counted or summed). In this example the fields Areas, Bandings, Boroughs and hour are Page fields. They will therefore have drop down menus on them, and will appear at the top left of the spreadsheet.

The Libraries field is in the ROW area because it was moved into the pivot table.

All fields (those with shadows) on the right hand side of the screen can be used in the Pivot Table.

  1. Use your mouse to drag and drop fields into or out of the Pivot Table, as required.

  2. Click OK to accept the changes.
    This will return you to the     Pivot Table and Pivot Chart Wizard - Step 3 of 3.

  3. Click Finish to update the Pivot Table with your changes.

Note:  This process edits the report you are viewing. It does not change the original report template. This means that you can view the original report again at any time, by returning to ArteMIS and choosing to view that report.