software

I am trying to group some dates in a pivot table, however when I select the
field, right click and select quot;groupquot;, I get an error - quot;Can't group that
selectionquot;. I have checked that the field is formatted correctly (dates). Any
suggestions?

Hi,

Make sure you have no blank rows in your Pivotdata range, and that you
have no blank cells in your date range. The data grouping wont work in
those cases.

Regards

Govind.

Johnson748r wrote:
gt; I am trying to group some dates in a pivot table, however when I select the
gt; field, right click and select quot;groupquot;, I get an error - quot;Can't group that
gt; selectionquot;. I have checked that the field is formatted correctly (dates). Any
gt; suggestions?

Thanks Govind.

quot;Govindquot; wrote:

gt; Hi,
gt;
gt; Make sure you have no blank rows in your Pivotdata range, and that you
gt; have no blank cells in your date range. The data grouping wont work in
gt; those cases.
gt;
gt; Regards
gt;
gt; Govind.
gt;
gt; Johnson748r wrote:
gt; gt; I am trying to group some dates in a pivot table, however when I select the
gt; gt; field, right click and select quot;groupquot;, I get an error - quot;Can't group that
gt; gt; selectionquot;. I have checked that the field is formatted correctly (dates). Any
gt; gt; suggestions?
gt;

I am getting the same error. I've reformatted the dates various ways and I
get get my spreadsheet to group by quarters. I've tried rearranging my pivot
table, removed any blanks, etc. I've never had a problem like this come up
before. ANy suggestions?

quot;Johnson748rquot; wrote:

gt; I am trying to group some dates in a pivot table, however when I select the
gt; field, right click and select quot;groupquot;, I get an error - quot;Can't group that
gt; selectionquot;. I have checked that the field is formatted correctly (dates). Any
gt; suggestions?

If there are quot;Blankquot; elements in your pivot table, edit the source data to
eleminate them by either adding the word quot;Blankquot; or deleting. Refresh the
table and then try to group again.
--
TX-CPAquot;sbates26quot; wrote:

gt; I am getting the same error. I've reformatted the dates various ways and I
gt; get get my spreadsheet to group by quarters. I've tried rearranging my pivot
gt; table, removed any blanks, etc. I've never had a problem like this come up
gt; before. ANy suggestions?
gt;
gt; quot;Johnson748rquot; wrote:
gt;
gt; gt; I am trying to group some dates in a pivot table, however when I select the
gt; gt; field, right click and select quot;groupquot;, I get an error - quot;Can't group that
gt; gt; selectionquot;. I have checked that the field is formatted correctly (dates). Any
gt; gt; suggestions?