Creating a Pivot Table in this Workbook¶

Pivot tables are dynamic and interactive charts that are easily created and assist with analyzing large amounts of data without creating complex formulas. You can rearrange a pivot table in many ways.  If you build it to show the same commodity over several markets, you can rotate the row and column headings to display all the commodities in a specific market.  Pivot tables can analyze percentage changes in prices over time, provide a list of prices during a specific time period, and become the source table for a chart.  The most important step in the process is deciding what you want to know.  Follow these steps in your Price Bulletin workbook to create a pivot table:

1. Go to the Data tab and click on any cell in the table

2. Click on the Insert menu on the Excel ribbon, select the Pivot Table icon. The Create PivotTable dialog box will open.

3. Select a table or range is already selected with the name of the data table (New Worksheet is also selected for you as the place where the report will be placed, or you may choose a different location).

4. An area where you build the report and a pivot table field list will appear on the new sheet

5. Tip: The pivot table is active and field list accessible when the cursor is located on any cell inside the table.

6. Decide what you want to know before building the table

7. Move the desired criteria to the Report field by moving the selection to the Report Filter in one of the following three ways.

a. Select the check box next to the field name in the Field List to move to the appropriate field.
b. Right-click a field name and select a location to where you want to move the field
c. Select, drag and drop from the field list into the building area

You can change the order of the filtered items by clicking and dragging them to new positions in the list or filter.