Can't get PivotTable time grouping to work..
In older versions of excel I can easily "group" a time column and summarize it by day, month, etc. In Excel 2016 I can no longer get this to work with any data sets so far. Grouping the data just results in a "dumb" group with no summarization features.
I've found documentation of the "auto-grouping" feature for time in Excel, but this never seems to function or appear on my Mac....how can I replicate the legacy function??
Remove any blank or non-Date cells from your date column. That usually fixes it.
Anne Hickey commented
We are witnessing that the Grouping within a PivotTable works in the PC version but not the MAC v15.25
it appears to be the same problem as this that happened before and was fixed: