To group dates by month in a Pivot Table is easy when you know how. Unfortunately, displaying date values in a Pivot Table can produce unexpected results.

For example, in the Pivot Table below I have added a Date field to the Column area of my Pivot Table.  Every date in the underlying data table is different, therefore resulting in a column for every day and a very large Pivot Table. Continue Reading