Visualize - Creating a Pivot

Cory Fifield -

Note: All Visualize examples are done with the Northwinds sample database. If you would like to use the Northwinds database as well, click here. This impacts the fields used in creating the Pivot.

 

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 Shipping Fee 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 State/Province field into Rows.
  6. Drag the City field below State/Province.
  7. Click the Arrow inside the Pivot to display the second row (city) grouped by the State/Province.

 

This example displays Shipping Fees grouped by State and City.

 

Example Creating a Pivot
Visualize-Training_Pivot.gif

Have more questions? Submit a request

Comments

Powered by Zendesk