|
|
|
|
font help bookshelf TOC thumbnails | 12 of 35 |
|
|
| Excel 2000 : A Sample Application Pivot Tables |
Now all of the Date entries appear, which isn't necessarily what we want. If we wanted to look at all of the raw Date data, we could have stayed with the original data table.
Let's group the Dates by month. Right-click on any cell with Date data. A pop-up menu appears. Choose Group and Outline - Group.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |