Pivot
Explorer 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 supports all SharePoint list apps,
whether 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 button in a list, a
report suggestion from the list data will be created. When
at least one report has been saved, the existing reports
for that list will be displayed instead.
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
Example lists with reports, for evaluation
The SPFX edition edition works in MicrosoftTeams.
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.