software

I have created a Pivot Table the is groups my date by Days = 7. I then
wanted to add a Month grouping that would keep the days in the correct month
even if the week is split. I have done this in the past with no problem but
after upgrading to Office 2003 the pivot table is reverting the Day grouping
to 1. Any ideas how to correct this?

Hi Monica

Also on XL2003.
It does still group by 7 day periods, even when you add Months (and
Quarters), but I agree that the selection box for number of days which
becomes greyed out, does revert back to 1, even though my report still
does do the grouping in weekly intervals.

--
Regards

Roger Govierquot;Monica Hallquot; gt; wrote in message
...
gt;I have created a Pivot Table the is groups my date by Days = 7. I
gt;then
gt; wanted to add a Month grouping that would keep the days in the correct
gt; month
gt; even if the week is split. I have done this in the past with no
gt; problem but
gt; after upgrading to Office 2003 the pivot table is reverting the Day
gt; grouping
gt; to 1. Any ideas how to correct this?
I'm starting to think I have a bug in my software because my grouping does
revert to 1 day even when I enter 7 then select the Month. I've tried
grouping by days only first and it groups just fine. I then go back to the
grouping and select month the day box shows 7 but when I hit okay the table
changes to Month and 1 day group. Frustating!

Monicaquot;Roger Govierquot; wrote:

gt; Hi Monica
gt;
gt; Also on XL2003.
gt; It does still group by 7 day periods, even when you add Months (and
gt; Quarters), but I agree that the selection box for number of days which
gt; becomes greyed out, does revert back to 1, even though my report still
gt; does do the grouping in weekly intervals.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Monica Hallquot; gt; wrote in message
gt; ...
gt; gt;I have created a Pivot Table the is groups my date by Days = 7. I
gt; gt;then
gt; gt; wanted to add a Month grouping that would keep the days in the correct
gt; gt; month
gt; gt; even if the week is split. I have done this in the past with no
gt; gt; problem but
gt; gt; after upgrading to Office 2003 the pivot table is reverting the Day
gt; gt; grouping
gt; gt; to 1. Any ideas how to correct this?
gt;
gt;
gt;

Hi Monica

My apologies, for I fear I may have misled you. You do not have a bug in
your software.
On looking back at my test data, the individual dates did happen to all
be the same day of the week, therefore I was quot;fooledquot; into thinking the
PT was still grouping on a 7 day frequency inside of Month frequency.
It does lose the 7 day grouping, once Month or Quarter is applied, and
does go back to individual days as you describe.

I just tried it on my wife's computer, XL2002 SP3, and that behaves the
same.
I don't have access to a machine with XL2000 and XL97 just at the
moment, so I can't go back to explore the behaviour in those versions.
I have tried changing the starting date to every different weekday to
see if that makes any difference, but it doesn't, so I'm afraid I have
no workaround for you.

There may be a VB solution, but I can't think of one.

--
Regards

Roger Govierquot;Monica Hallquot; gt; wrote in message
news
gt; I'm starting to think I have a bug in my software because my grouping
gt; does
gt; revert to 1 day even when I enter 7 then select the Month. I've
gt; tried
gt; grouping by days only first and it groups just fine. I then go back
gt; to the
gt; grouping and select month the day box shows 7 but when I hit okay the
gt; table
gt; changes to Month and 1 day group. Frustating!
gt;
gt; Monica
gt;
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Monica
gt;gt;
gt;gt; Also on XL2003.
gt;gt; It does still group by 7 day periods, even when you add Months (and
gt;gt; Quarters), but I agree that the selection box for number of days
gt;gt; which
gt;gt; becomes greyed out, does revert back to 1, even though my report
gt;gt; still
gt;gt; does do the grouping in weekly intervals.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Monica Hallquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have created a Pivot Table the is groups my date by Days = 7. I
gt;gt; gt;then
gt;gt; gt; wanted to add a Month grouping that would keep the days in the
gt;gt; gt; correct
gt;gt; gt; month
gt;gt; gt; even if the week is split. I have done this in the past with no
gt;gt; gt; problem but
gt;gt; gt; after upgrading to Office 2003 the pivot table is reverting the Day
gt;gt; gt; grouping
gt;gt; gt; to 1. Any ideas how to correct this?
gt;gt;
gt;gt;
gt;gt;
I tried a couple of things using VB code. But was unable to get the days to
stick. I don't have a lot of time to spend on this issue but it is driving
me crazy. Microsoft help says that you should be able to group multiple days
and month.

Thank you,
Monica

quot;Roger Govierquot; wrote:

gt; Hi Monica
gt;
gt; My apologies, for I fear I may have misled you. You do not have a bug in
gt; your software.
gt; On looking back at my test data, the individual dates did happen to all
gt; be the same day of the week, therefore I was quot;fooledquot; into thinking the
gt; PT was still grouping on a 7 day frequency inside of Month frequency.
gt; It does lose the 7 day grouping, once Month or Quarter is applied, and
gt; does go back to individual days as you describe.
gt;
gt; I just tried it on my wife's computer, XL2002 SP3, and that behaves the
gt; same.
gt; I don't have access to a machine with XL2000 and XL97 just at the
gt; moment, so I can't go back to explore the behaviour in those versions.
gt; I have tried changing the starting date to every different weekday to
gt; see if that makes any difference, but it doesn't, so I'm afraid I have
gt; no workaround for you.
gt;
gt; There may be a VB solution, but I can't think of one.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Monica Hallquot; gt; wrote in message
gt; news
gt; gt; I'm starting to think I have a bug in my software because my grouping
gt; gt; does
gt; gt; revert to 1 day even when I enter 7 then select the Month. I've
gt; gt; tried
gt; gt; grouping by days only first and it groups just fine. I then go back
gt; gt; to the
gt; gt; grouping and select month the day box shows 7 but when I hit okay the
gt; gt; table
gt; gt; changes to Month and 1 day group. Frustating!
gt; gt;
gt; gt; Monica
gt; gt;
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi Monica
gt; gt;gt;
gt; gt;gt; Also on XL2003.
gt; gt;gt; It does still group by 7 day periods, even when you add Months (and
gt; gt;gt; Quarters), but I agree that the selection box for number of days
gt; gt;gt; which
gt; gt;gt; becomes greyed out, does revert back to 1, even though my report
gt; gt;gt; still
gt; gt;gt; does do the grouping in weekly intervals.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Monica Hallquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have created a Pivot Table the is groups my date by Days = 7. I
gt; gt;gt; gt;then
gt; gt;gt; gt; wanted to add a Month grouping that would keep the days in the
gt; gt;gt; gt; correct
gt; gt;gt; gt; month
gt; gt;gt; gt; even if the week is split. I have done this in the past with no
gt; gt;gt; gt; problem but
gt; gt;gt; gt; after upgrading to Office 2003 the pivot table is reverting the Day
gt; gt;gt; gt; grouping
gt; gt;gt; gt; to 1. Any ideas how to correct this?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Hi Monica

I have tried again and also failed.
The only workaround that I can think of at the moment is perhaps to have
another column in your source table, and use the Weeknum() feature from
the Analysis Toolpack.
=Weeknum(your_date)
Then allocate this field to the PT as well, and you would see data
grouped by Weeknum inside Month.

If Debra Dalgleish spots this post, she may well be able to come up with
a quot;correctquot; solution for you.

--
Regards

Roger Govierquot;Monica Hallquot; gt; wrote in message
...
gt;I tried a couple of things using VB code. But was unable to get the
gt;days to
gt; stick. I don't have a lot of time to spend on this issue but it is
gt; driving
gt; me crazy. Microsoft help says that you should be able to group
gt; multiple days
gt; and month.
gt;
gt; Thank you,
gt; Monica
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Monica
gt;gt;
gt;gt; My apologies, for I fear I may have misled you. You do not have a bug
gt;gt; in
gt;gt; your software.
gt;gt; On looking back at my test data, the individual dates did happen to
gt;gt; all
gt;gt; be the same day of the week, therefore I was quot;fooledquot; into thinking
gt;gt; the
gt;gt; PT was still grouping on a 7 day frequency inside of Month frequency.
gt;gt; It does lose the 7 day grouping, once Month or Quarter is applied,
gt;gt; and
gt;gt; does go back to individual days as you describe.
gt;gt;
gt;gt; I just tried it on my wife's computer, XL2002 SP3, and that behaves
gt;gt; the
gt;gt; same.
gt;gt; I don't have access to a machine with XL2000 and XL97 just at the
gt;gt; moment, so I can't go back to explore the behaviour in those
gt;gt; versions.
gt;gt; I have tried changing the starting date to every different weekday to
gt;gt; see if that makes any difference, but it doesn't, so I'm afraid I
gt;gt; have
gt;gt; no workaround for you.
gt;gt;
gt;gt; There may be a VB solution, but I can't think of one.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Monica Hallquot; gt; wrote in message
gt;gt; news
gt;gt; gt; I'm starting to think I have a bug in my software because my
gt;gt; gt; grouping
gt;gt; gt; does
gt;gt; gt; revert to 1 day even when I enter 7 then select the Month. I've
gt;gt; gt; tried
gt;gt; gt; grouping by days only first and it groups just fine. I then go
gt;gt; gt; back
gt;gt; gt; to the
gt;gt; gt; grouping and select month the day box shows 7 but when I hit okay
gt;gt; gt; the
gt;gt; gt; table
gt;gt; gt; changes to Month and 1 day group. Frustating!
gt;gt; gt;
gt;gt; gt; Monica
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Roger Govierquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi Monica
gt;gt; gt;gt;
gt;gt; gt;gt; Also on XL2003.
gt;gt; gt;gt; It does still group by 7 day periods, even when you add Months
gt;gt; gt;gt; (and
gt;gt; gt;gt; Quarters), but I agree that the selection box for number of days
gt;gt; gt;gt; which
gt;gt; gt;gt; becomes greyed out, does revert back to 1, even though my report
gt;gt; gt;gt; still
gt;gt; gt;gt; does do the grouping in weekly intervals.
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Regards
gt;gt; gt;gt;
gt;gt; gt;gt; Roger Govier
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Monica Hallquot; gt; wrote in
gt;gt; gt;gt; message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have created a Pivot Table the is groups my date by Days = 7.
gt;gt; gt;gt; gt;I
gt;gt; gt;gt; gt;then
gt;gt; gt;gt; gt; wanted to add a Month grouping that would keep the days in the
gt;gt; gt;gt; gt; correct
gt;gt; gt;gt; gt; month
gt;gt; gt;gt; gt; even if the week is split. I have done this in the past with
gt;gt; gt;gt; gt; no
gt;gt; gt;gt; gt; problem but
gt;gt; gt;gt; gt; after upgrading to Office 2003 the pivot table is reverting the
gt;gt; gt;gt; gt; Day
gt;gt; gt;gt; gt; grouping
gt;gt; gt;gt; gt; to 1. Any ideas how to correct this?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;