How to group if source from different sheets?

[andy.k]

Hello All,

I have data that has many dates, and I was playing with grouping, and it works if pivot table is created referencing data on same sheet. What I've got is two sheets that I'm referencing data from. If I right click on date column, and select group, it creates "group1" option, and it does not give me option to group by day/month/year etc.

Am I doing something wrong?

Thanks.

[Pepe Le Mokko]

It could be that :
- the range contains empty cells which you will have to eliminate
- some dates are text looking like dates not real dates
The latter can eventually be fixed by selecting the date range in your source data - Data - Text to columns - Finish

If it does not work, post a sample sheet