Pivot Table Date Grouping Problem
Have you ever tried to group dates in a pivot table and been told that you can’t group that selection? It’s very frustrating because you have no way of knowing what’s causing the pivot table error. There’s a great article that explains what causes this problem and how to fix it. Check it out below:
Date problem: ‘Cannot group that selection’
One great feature of pivot tables is their ability to group dates into monthly or weekly totals. But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work. If you try to group a row of dates and get the message “Cannot Group that Selection”, it means that one or more of your dates is faulty.
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
