A new version of our PivotPoint web part for SharePoint (v2.2.3) is ready.
This new version improves performance for large lists, corrects bugs when you have angled brackets (“<” and “>”) in your row or columns, adds support for site column lookups and a 2 new features.
The new version of PivotPoint allows you to sort by both the Title and Total rows, either ascending or descending.
For example, instead of sorting alphabetically by product you can sort by their total sales – showing your best performing products at the top of the table or left of the chart.
More details are in the online manual.
In combination with sorting by the Total you can choose to show the Top N columns or rows.
For example given the following data the vast majority of revenue comes from 2 products (Bottle-o-matic and Can-o-Matic) and we have a ‘Long Tail’ of other products.
We can choose to only display the top 2 columns (products) and optionally group all the other sales into “Other”
You can download and upgrade to the latest version without losing any settings.