- Knowledge Base
This section of PivotPoints configuration toolpart allows you to specify how the Add New Item link and Export to Excel options work and Crop the row and column labels.
You can add a link to PivotPoint to add items directly to your list. You can choose from :-
PivotPoint Caption - Add New Item and Excel Export
You can export the Pivot Table to Microsoft Excel 2003+ for further analysis & reporting. You can choose from :-
Web Part Menu - Excel Export
You can crop text out of the row and column labels using these options. This is useful for situations where you have very long labels such as when you've added extra information into the labels to control the sorting.
For example SharePoint's Task list template uses a Priority column that has the following values - (1) High, (2) Medium & (3) Low - to enforce a sensible order when sorted alphabetically. If it wasn't for the number at the start of the status then alphabetical sorting would list High, Low, Medium.
This trick is often used when sorting dates - e.g. we want an order of "Jan 2011, Apr 2011, July 2012" instead of "Jan 2011, July 2012, Apr 2011" so we can add "YYYY-MM" to the front of the label to enforce the correct order, for example "(2011-01) Jan 2011, (2011-04) Apr 2011" and so on. For an example of this technique see the FAQ - How to drill down on Month and Year.
These sorting prefixes can be ugly though, so PivotPoint allows you to crop them them out.
If you are sorting by the Total row/column then you have the option to show only the Top N rows or columns - this can be useful in cases where you may have a 'long tail' of data that you don't wish to display.
For example given the following, the vast majority of revenue comes from 2 products (Bottle-o-matic and Can-o-matic) :-
We can choose to display only the top 2 Columns (products) and group all other sales into "Other".
Tip - if you want to show "Bottom N" records rather than "Top N" then just set the sort order to Descending as well.