A very frustrating aspect of PivotTables is where you receive a message that Pivot Table group dates by month cannot group that selection. This also happens when you try other groupings.
The reason for this seems to be how Microsoft Excel sees the data.
For example if you have 999 cells that contain a valid Excel date, and only 1 cell that is a blank or a date that excel doesn’t recognise you will get the message that ‘Pivot Table group dates by month cannot group that selection’.
To get the PivotTable to perform the grouping you will need to change the problem cells to more acceptable entries. Change blanks to a zero or dates into Excel acceptable dates.
Dates are often a problem in PivotTables so we often recommend that clients create a new column in the underlying data that does any of the grouping they need and then pull through these grouped columns into the Pivot Table.
PowerPivot Format Percentage for DAX Measure One of the most useful features of the new DAX measures in PowerPivot is the ability to specify a set format for the measure so that every time you use it in a pivot … Continue reading
Excel Quiz Answers Answers for the quiz on our 26th Nov 2014 Newsletter. To subscribe to the newsletter visit the subscribe page. Excel Questions from the Newsletter What is the easiest way to set up a range so that it … Continue reading
...Not only did I learn a lot about Access on this course, but I also gained quite a few useful Excel skills. The fact that Jonny is an accountant meant that he understood the daily challenges with data in a finance role...– Excel with access- Hannover Re