<b>Pivot Tip 18</b> - Date problem: 'Cannot group that selection'

Kashflow logo
Share this content

ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database.

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.

Check for faulty dates by sorting the database into date order. Any faulty dates will be found in the first and last rows. Once you have corrected the faulty dates, go into the pivot table and press the Refresh Data button. But you will have to refresh the data TWI...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.