Unlock the Secrets in Your SharePoint Lists . . . .

Pentalogic Pivot Points provides fast and flexible analysis of the numerical data in your SharePoint lists, with no need to link to Excel.

Pivot Point allows you to summarize and analyze the numerical data in your lists, providing an instant snapshot of your key data and dashboard views where you team can see trends emerging as list items are added and updated.

The software works by performing a cross-tabulation on your list data, similar to an Excel Pivot Table: extracting meaningful data from long and complex lists by summarizing and sorting in a variety of different ways.

Didn't this used to be called "Cross Tab"? Well spotted! Yes it did.  We changed the name because no one seemed to understand the old name, and we didn't feel it did the product much justice. So new name - but it still does all the same great stuff!

Example Uses

Sales Analysis Analyze sales lists to compare performance of different products, sales teams or time periods.   From a simple list of individual sales transactions Pivot Point can group sales by month, quarter or year and show results for products or sales teams as currency values, % of total, or items sold.  Once the web part is set up, changes to the list will update team members dashboard displays - allowing you to keep track of sales performance in real time.

On Call Rota In this example we apply Pivot Point to a standard calendar list, being used to manage an On Call rota.  We get an instant snap shot which shows us who is pulling most of the night shifts.  Pivot Point can be used in exactly the same way to monitor any sort of resource usage.

Key Features

• Apply to lists, or list views
• Dashboard updates as list data changes
• Cross Tabulation functionality
• Summarize data by date range
• display multiple cell values simultaneously with Tool tips
• Performs a rang of calculations: sum, sum as %, count, count as %, average, range, Min, Max and Standard Deviation
• Dynamic Filtering
• Printable Dashboards

FAQ

Which versions of Microsoft SharePoint is Pentalogic Pivot Point compatible with?

WSS v2 - Microsoft Windows SharePoint Services v2 (WSS 2.0) or Microsoft SharePoint Portal Server 2003 (SPS 2003).

WSS v3 - Microsoft Windows SharePoint Services v3 (WSS 3.0) or Microsoft Office SharePoint Server 2007 (MOSS 2007).

How do I use Pentalogic Pivot Point?

Pivot Point is delivered as a SharePoint WebPart. Once installed on a SharePoint server you add it to a WebPart page and then configure it to display data from one of your Lists.

Does Pivot Point need any client software of ActiveX/Java Applets installed?

No - it works using standard HTML only, no client software is required.

What languages does Pivot Point support?

Pivot Point supports all of the language packs for SharePoint that have been released by Microsoft, including those languages that use a non-Roman alphabet and require Unicode support, however the Administration interface and error messages are currently only available in in English