• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table group data missing entries


New Member

I am experiencing two problems with my pivot table:

a) Want to group dates in months. Pivot table gives error message "Cannot group that selection". Cells in data table are formatted as dates, not text.

b) The pivot table does not reflect all the entries from my data table, e.g not all customers are listed - why?

Excel 2003, Windows Professional XP.

By the way, PHD, any chance of a search function for Ask an Excel Question? Then I can first check to see if my question has been addressed, before submitting it.

Great site, even greater visitors!
I discovered the reason why the Pivot Table does not group dates - it does not accept any blanks in the Date column of the database. Anybody know of a work-around?