Create a pivot

In this step, you'll create a pivot (also known as a pivot table) based on the data in the dataset. Pivots let you analyze different subsets of your data using more advanced features than are included for table views. In a pivot, you can create data dimensions for the data you want to analyze, add data measures and calculated measures, and configure the axes of the pivot to display the information you want. The following sections describe different aspects of creating a pivot.

• Pivot data dimensions

• Pivot data measures and calculated measures

• Pivot selectors

• Pivot report style

• Pivot axes

• Final pivot creation

Related Topics

• Prerequisites
• Full scripts
• Create the dataset
• Set up the workbook
• Create a table view
• Tutorial: Creating a Workbook Using the Workbook API

General Notices