Grouping Problem in Pivot
 

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

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

Grouping Problem in Pivot
 

Thank you. I looked for empty cells or text but cannot find them. Is there
a way to double check? Seems simple but I am stuck. Thanks.

"Dave Peterson" wrote:

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

Grouping Problem in Pivot
 

There are some suggestions for fixing the problem he

http://www.contextures.com/xlPivot07.html#Problems

ADub wrote:
Thank you. I looked for empty cells or text but cannot find them. Is there
a way to double check? Seems simple but I am stuck. Thanks.

"Dave Peterson" wrote:


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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html