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.