Creating a Pivot

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

Basic Pivot Steps:

  1. Change the Data Source to Detail.
  2. Click the Pivot icon to insert this element into the Data Visualization.
  3. Drag a field into the Value.
  4. Drag a field into Columns.
  5. Drag a field into Rows.

 

Example Northwinds Pivot:

  1. Change the Data Source to Detail.
  2. Click the Pivot icon to insert this element into the Data Visualization.
  3. Drag the Freight field into the Value.
  4. Drag the Order Date field into Columns.
    • Click the drop down for Order Date.
    • Change from (Year) to (Month-Year)
  5. Drag the EmployeeID field into Rows.
  6. Drag the City field below EmployeeID in Rows.
  7. Click the Arrow inside the Pivot to display the second row (city) grouped by the EmployeeID.

 

This example displays Freight grouped by EmployeeID and City.

 

Example Creating a Pivot
mceclip0.png

Have more questions? Submit a request

Comments