Hi Shams

You say that your date column is of valid Excel date formats, but does your
range include any blank cells. This will cause Excel to give the message
can't group by Date, or any spurious text in a cell will give the same message.
Ensure you have dates for every row in your table that is being summarised
by the PT, or, make the range dynamic so as to only select a range that
contains data.


Regards

Roger Govier


Shams wrote:
Folks,
I am trying to do a pivot table that will use the following data to first
sum the subtotal by Product and then Date. In this Case, I want Pivot to
Group by Date such as BA for January 2004 is 1,703.44. So, I am creating the
Pivot table selecting Product and Date under Rows and then summing by
subtotal. From my report, I try to right-mouse click on the Date field and
try to select Group. Excel comes back saying that it cannot Group that
selection. I am not sure why that's happening. My Date field is of the Date
format. Can somebody please help? Thanks.

DATE PRODUCT SUBTOTAL

1/1/2004 BA 256.36
1/9/2004 BA 369.36
1/15/2004 BA 482.36
1/29/2004 BA 595.36
3/15/2004 BA 708.36
6/15/2004 BA 821.36
12/31/2004 BA 934.36
1/16/2005 BA 1047.36
1/17/2005 BA 1160.36
1/18/2005 BA 1273.36
1/19/2005 BA 1386.36
03/15/2004 BH 123.36
06/15/2004 BH 123.36
09/15/2004 BH 365.36
1/23/2005 BH 1499.36
2/22/2005 BH 1612.36
3/29/2005 BH 1725.36
5/15/2005 BH 1838.36