I have set up a pivot table with dates in Col A. I would like to group the dates into months. however, when I select Col A and select group. I get a message "Cannot group that selection"
I have posted some sample data
Your assistance in this regard is most appreciated
http://windowssecrets.com/forums/sh...es-in-Months-Pivot-Tables?p=868824#post868824
I have posted some sample data
Your assistance in this regard is most appreciated
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
3 | Dates | Sales | ||
4 | 13/07/2012 15:35 | 751.79 | ||
5 | 13/08/2012 12:33 | 391.1 | ||
6 | 13/08/2012 15:19 | 172.5 | ||
7 | 13/08/2012 15:29 | 73.5 | ||
8 | 14/07/2012 09:00 | 2433.3 | ||
9 | 14/08/2012 12:02 | 879.05 | ||
10 | 14/08/2012 14:02 | 1866.18 | ||
11 | 14/08/2012 16:22 | 8451.7 | ||
12 | 14/08/2012 16:31 | 840.75 | ||
13 | 14/08/2012 16:41 | 70 | ||
14 | 15/08/2012 08:11 | 2430.79 | ||
15 | 15/08/2012 08:34 | 119.84 | ||
Sheet4 |
http://windowssecrets.com/forums/sh...es-in-Months-Pivot-Tables?p=868824#post868824
Last edited: