Pivot tables

Pivot tables are a very powerful way to report across multiple elements. Drag fields into the left hand column and top row to display a count of matches. To show a third set of data, use the settings in the top left-hand corner.

Use any of the filters below with a Pivot table display.

To open the pivot table builder

• Click the Config button
• Choose Pivot table from the Displays column
• Click Apply

Example 1: Number of training items a user has at each stage of completion

• Drag the Username bubble to the left hand column
• Drag the Status bubble to the top row

Example 2: Status of each training item for each user

• Drag the Username bubble to the left hand column
• Drag the Title bubble to the top row
• Change the pivot action in the left top corner from Count to List Unique Values
• Choose Status in the second box that appears