Jan 16 2023 01:17 PM
In the pivot table I have set up, it is organized by days, but whenever I try to group it by week, it doesn't allow me the option.
From looking up on other websites, a grouping dialogue should pop up to allow me to enter a starting and ending date, but no such dialogue occurs for me whenever I try to group. Whenever I try to right click a date, it gives me a message saying
I have tried on both Windows and Mac, but I get the same result and I cannot group my PivotTable by week.
Any help on what my problem is? Could it be the software itself?
Jan 16 2023 01:28 PM
Jan 16 2023 01:30 PM
Are you sure that the values are real dates and not text values looking like dates?
Does the date column in the data source contain empty cells, or non-date values?