View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Grouping Problem in Pivot

If you have text or empty cells in that field, you won't be able to group that
field.

ADub wrote:

I am trying to group dates so they sum by month. I keep getting a pop-up
window that says 'Cannot Group that selection'. I have tried different data
sets but keep getting the same result. What am I doing wrong? Thank you.

Adam


--

Dave Peterson