Pivot Tables

• Pivot tables represent data within multiple categorizations, such as totals per area, summarized by year and by month.

  Figure B-16 Example BI Publisher Pivot Table

  

• To add a pivot table, click Insert / Pivot Table and drag the required categorization or grouping data elements from the left pane to the right-hand Layout pane.

• Set the type to Sum or Count and click OK to add the table.

• Apply any formatting or styling required. Ensure the column widths are sufficient, otherwise the data will be truncated.