Forum Discussion
Unable to group by date in Pivot Table
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 po...
The inability to group on date usually suggests there's at least one text item in the dates column. It could be something as simple as a bad date or an obvious text entry. Go to the source data, drop a filter on the data, and inspect the filter. If there's an entry (or two) that doesn't consolidate with your dates, you have the answer.