Creating a Pivot
Trouble viewing images? Click on images to enlarge.
Basic Pivot Steps:
- Change the Data Source to Detail.
- Click the Pivot icon to insert this element into the Data Visualization.
- Drag a field into the Value.
- Drag a field into Columns.
- Drag a field into Rows.
Example Northwinds Pivot:
- Change the Data Source to Detail.
- Click the Pivot icon to insert this element into the Data Visualization.
- Drag the Freight field into the Value.
- Drag the Order Date field into Columns.
- Click the drop down for Order Date.
- Change from (Year) to (Month-Year)
- Drag the EmployeeID field into Rows.
- Drag the City field below EmployeeID in Rows.
- 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
Comments
0 comments
Please sign in to leave a comment.