Pivot Tip #30: Use =MONTH and =YEAR functions to summarise dates. By David Carter
David Carter’s series of Five Minute Tips aims to develop your skill at using Excel pivot tables. If you want to test the tip for yourself, David takes you through a worked example on the pivot practice database.
If you want to summarise transactions by month, Group is the obvious way to do it.
But if just one record out of thousands contains a faulty date or blank cell, then Group doesn’t work and gives the “Cannot Group this selection” message.
Personally, I don’t use Group any more.