BIP Template – Pivot Table and Chart
- Pivot Table – A Pivot Table is a tool that allows you to reorganize and summarize selected columns and rows of data to obtain a desired report.
- Chart – There currently are no chart demonstrations.
Pivot Table Illustration
This is a basic demonstration of how to set up a Pivot Table in a BI Publisher Word Template.
You may be familiar with pivot tables in Microsoft Excel. For example, they can be useful for condensing information that you run from a PS Query.
Pivot Table is one of the options on the Insert menu in BI Publisher Word Template.
As with Excel, the pivot table in the template allows you to reorganize and summarize selected columns and rows of data to obtain a desired report. Among other functions, the pivot table can automatically sort, count, total or give the average of the data. The results are displayed in the template in a table showing the summarized data.
The user sets up and changes the summary’s structure by dragging and dropping fields graphically. This “rotation” or pivoting of the summary table gives the concept its name.
