This example is based on the Work Orders workbook, used in my book, Beginning PivotTables in Excel 2007.
If you’re working through the book, this video shows the steps outlined starting on page 46.
In the video, we create a pivot table that’s based on a formatted Excel Table.
Then, the Values field is changed from SUM to AVERAGE, and the numbers are formatted so they’re easy to read and understand.
___________________
I have dates to be summarised on pivot tables, but I want to summerize by Months and Years. How do I change the column settings to specify months?
@David, you can group the dates by months and years, as described on this page on my Contextures website: http://www.contextures.com/xlPivot07.html
Thanks so much for your reply – all sorted now, as I needed to firstly ungroup several levels.