Forum Discussion
Solved
Pivot Table - Date - Group by Month does not work
Dear all, I am working on my departments budget, and wish to show the costs per month. However, invoices are registered across the month (on 02/01/2019, 05/01/2019, 13/01/2019, ...). Now, the aim is...
So you have your pivot set like this and then right click on date and you don't get the Group Option?
SBiebaut86 I was having the exact same issue and suddenly it started working after I changed my date format to M, so I guess that's the work around.
- Avoid having anything else in your row labels box except date and then try grouping
