Odd behavior in pivot table

[Sean15]

Hi:

I'm trying to group dates by month and year (right click on pivot table, group) but Excel is inserting 'Group1' in pivot table and 'Date2' in pivot table field list as shown in image below.

Why is the odd behavior occurring and how can I fix it?

Thanks

Regards,

Sean

 

[stanco]

Hi:

I'm trying to group dates by month and year (right click on pivot table, group) but Excel is inserting 'Group1' in pivot table and 'Date2' in pivot table field list as shown in image below.

Why is the odd behavior occurring and how can I fix it?

Thanks

Regards,

Sean

are there blank cells in the date column of your original table?

 

[Sean15]

Hi:

There are no blank cells in date column. I did a TRIM to remove leading spaces. I also formatted numbers as dates. But, Excel is still displaying odd behavior explained in post #1 .

Could someone advise please.

Regards

Sean

 

[tcardwell]

Hello Sean15,

Pretty sure it is tied to the fact that you have two date fields in your row labels area. One group is for Date2 and another group is for Date.