software

I'm following the FAQ for taking a list of dates produced by my piviot table
and trying to group them by week. When I select the field name, right click
and select grouping, I get quot;cannot group by the selectionquot;. My data source
for this field in the table is all dates (other than the header).
--
Thanks!

Maybe you've included some blank rows at the end of the source data, or
some of the dates are entered as text. There are suggestions for fixing
the problem he

www.contextures.com/xlPivot07.html#Problems

DoubleACL wrote:
gt; I'm following the FAQ for taking a list of dates produced by my piviot table
gt; and trying to group them by week. When I select the field name, right click
gt; and select grouping, I get quot;cannot group by the selectionquot;. My data source
gt; for this field in the table is all dates (other than the header).--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlGot it. My data has a lot of blanks, and if I delete the rows containing the
blank fields, I can build a grouping selection. Normally, I can remove the
blanks from being reported in my Pivot Table by deselecting blanks in the
field options box. However for grouping, I find that merely deselecting
blanks does not then allow grouping; the data itself cannot have blanks,
which is going to be a pain. I'm going to have to create some temporary
tables to accomplish the grouped report, unless you know of any other
solution.
--
Thanks!quot;Debra Dalgleishquot; wrote:

gt; Maybe you've included some blank rows at the end of the source data, or
gt; some of the dates are entered as text. There are suggestions for fixing
gt; the problem he
gt;
gt; www.contextures.com/xlPivot07.html#Problems
gt;
gt; DoubleACL wrote:
gt; gt; I'm following the FAQ for taking a list of dates produced by my piviot table
gt; gt; and trying to group them by week. When I select the field name, right click
gt; gt; and select grouping, I get quot;cannot group by the selectionquot;. My data source
gt; gt; for this field in the table is all dates (other than the header).
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

I often get a similar issue when using a data dump form our pricing system,
but the blanks are usually associated with zero value items, so what i do is
select the entire range of dates, do edit / Go to / Special / Blanks and
then enter in the lowest date (can be any date) that exists in my data and
use CTRL ENTER to enter it. This puts it in every blank cell, and then all
you need to do is refresh the PT. Because they are zero value items, it
doesn't matter that these now get included in the grouping.

Don't know if it will work for you, depends on your data, but worth
mentioning.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
quot;DoubleACLquot; gt; wrote in message
...
gt; Got it. My data has a lot of blanks, and if I delete the rows containing
gt; the
gt; blank fields, I can build a grouping selection. Normally, I can remove
gt; the
gt; blanks from being reported in my Pivot Table by deselecting blanks in the
gt; field options box. However for grouping, I find that merely deselecting
gt; blanks does not then allow grouping; the data itself cannot have blanks,
gt; which is going to be a pain. I'm going to have to create some temporary
gt; tables to accomplish the grouped report, unless you know of any other
gt; solution.
gt; --
gt; Thanks!
gt;
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;gt; Maybe you've included some blank rows at the end of the source data, or
gt;gt; some of the dates are entered as text. There are suggestions for fixing
gt;gt; the problem he
gt;gt;
gt;gt; www.contextures.com/xlPivot07.html#Problems
gt;gt;
gt;gt; DoubleACL wrote:
gt;gt; gt; I'm following the FAQ for taking a list of dates produced by my piviot
gt;gt; gt; table
gt;gt; gt; and trying to group them by week. When I select the field name, right
gt;gt; gt; click
gt;gt; gt; and select grouping, I get quot;cannot group by the selectionquot;. My data
gt;gt; gt; source
gt;gt; gt; for this field in the table is all dates (other than the header).
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Debra Dalgleish
gt;gt; Excel FAQ, Tips amp; Book List
gt;gt; www.contextures.com/tiptech.html
gt;gt;
gt;gt;