- First, you click in your data and select Insert>Pivot Table
- Then drag the field from the Field List Dialog box to the specified area.
- In my case I dragged Order Date to the ROW, Ship Via to the COLUMN and Order Amount to the VALUES section
to create the pivot table below.
- or in Excel 2010 you can also click on the Group Field icon on the contextual Pivot Table toolbar.
You can hide the individual months by clicking on the button immediately to the left tof the year or by right-clicking and selecting Expand/Collapse.
Also, if you take a look at the pivot table field list, you will see that you have a new field called Years that did not exist before. You can move this field around in the pivot table and you can even use it in a new pivot table that is based upon this one.