Pivot
Explorer makes it easy to visualize and analyze the
content of any SharePoint list. It works like an Excel Pivot
Table but for SharePoint lists, enabling users to create
interactive reports with pivot tables and charts directly
in SharePoint.
Pivot Explorer supports all modern SharePoint lists
and the classic Custom list, whether they are open in the
modern interface, the classic interface or Microsoft Lists.
Pivot Explorer gives you the usability and speed
of a desktop application and the mobility and scalability
of a web-based application.
The Pivot Explorer button
Pivot
Explorer 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 Pivot Explorerbutton
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.
The reports are shared with everyone that has access to
the list and automatically updated when the list is updated.
Kay features
The reports show 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
Example lists with reports, for evaluation,
available in all supported languages.
The SPFX edition edition works in Microsoft Teams.
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.
Editions
Pivot Explorer comes in two
editions and three different
packages:
SPFX edition
Sandboxed solution, installed manually or with PowerShell
script.
All is included in the subscription. Use what the organization
needs!