Pivot Explorer for SharePoint

Pivot Explorer for SharePoint makes it easy to visualize and analyze the content of any SharePoint list. Just as an Excel Pivot Table is a fantastic way to explore data in an Excel table, Pivot Explorer is what you should use for business intelligence to explore data in SharePoint lists.

Pivot Explorer gives the usability and speed of a desktop application and the mobility and scalability of a web-based application.. All SharePoint lists are supported, whether open in the modern interface, the classic interface or Microsoft Lists.

Pivot Explorer consists of a single client side extension SPFX package that adds a button to the command bar or ribbon in all SharePoint lists in sites where the product is installed. The first time a user clicks on the button in a list, a report suggestion from the list data will be created. When at least one report has been saved, the default report for that list will be displayed instead. Other reports are easily accessible from tabs above the current report. Example lists with reports are available for evaluators.

The reports are shared with everyone that has access to the list and automatically updated when the list is updated.

Features

• The report shows a pivot table and a chart.
• Fields selector to decide what data should

  be included in a report and how it should be displayed.

  Check a column name, and it will be added to one of

  the pivot table fields depending on data type. Drag

  and drop to modify.

• Save reports for quick access next time.
• Quickly switch between multiple reports for

  the list.

• Many possibilities to filter data.
• Export the pivot table to HTML, Excel or

  PDF

• Print the pivot table
• Conditional formatting
• Calculated values
• Four chart types to choose from
• Works in a Microsoft Teams tab when the list is added to a page.

Languages

The Pivot Explorer language is automatically set

to the same as the SharePoint site language.

Supported languages are: Arabic, Danish, Dutch, English,

French, German, Italian, Norwegian, Portuguese, Spanish

and Swedish. When the SharePoint site has another language, Pivot

Explorer will be in English.