Hi,
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 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!