Configuration

You base the PivotPoint web part on any view from the current site by selecting it in the dropdown.

You can optionally filter by any Public view defined on the list - if you don't choose a view then all records in the list will be used.

Using views gives you great flexibility to filter the data you want to include in the PivotPoint web part. This page may help if you are unfamiliar with SharePoint views.

You can select which field to use for the Column and/or Rows values.

You can choose to sort these values in Ascending or Descending order and if Totals should be displayed for the Rows/Columns

If the Column or Row is a Date field then you are given additional options on how to group different dates together.

In this example the grouping of "Month and Year" has been used :-

Sales growth example

You can choose which field to use for the Cells value and the calculation that should be applied. Depending on the data type of the field not all options will be available.

Summary	A comma separated list of values found in this field
Count	A Count of the number of records where this field was not empty
Count as %	The same as Count but expressed as a percentage of the Count grand total
Sum	A Sum of the values found in this field
Sum as %	The same as Sum but expressed as a percentage of the Sum grand total
Min	The smallest value found in this field
Max	The largest value found in this field
Range	The difference between the Min and Max values for this field
Average	The Arithmetic Mean of values found in this field
Std Dev	The Standard Deviation of values found in this field

A tooltip can be displayed when hovering over any particular cell. It can be useful to show the most important calculation in the PivotPoint's cells but provide other values as part of the tooltip.

You can (depending upon the data type of the Value field) choose the same calculations as shown above. This example shows a tooltip showing all the calculations available from a number field type :-

Tooltip example