Pivot Gadget is in Basic Maintenance mode.

From the toolbar, you can drag & drop dimensions on any of the pivot areas:

  • Filter
  • Columns
  • Rows 

The combination of filter, column and row dimension drives the calculation of the selected aggregation.

Aggregations can be dragged into the Measures box.

Limiting the number of entries on a dimension.

By clicking on the small '>' on the left side of the dimension, a drop-down will show listing all individual values of the dimension.  Toggle each of the checkboxes to select all relevant values.  Press OK to confirm your selection.

Export to Excel

Export raw statistics data and Pivot with selected dimensions and aggregations to Excel.

The collapse button

You can hide the toolbar by hitting the collapse button (or by resizing).

No toolbox in the graph


  • No labels