Pivot Table Group by Week?

[Guest]

Hello-

I see you can group pivot tables by month, year, quarter, etc..

What happen to 'by week'?

Thanks.

 

[Peo Sjoblom]

Use days and set them to 7 that will group like 01/01/05 - 01/07/05

 

[Guest]

Simply Beautiful.
Thank you Peo.

Now, can you help with my "Wrap data onto one page" question?

 

[Guest]

neat trick - if my data spans 2006 and 2007 I can't find a way to only show
2007 weekly values [since using days + years messes up the "7" grouping of
days].

Any ideas?

Thanks for your reply & assistance.
Jimbo213

 

[Debra Dalgleish]

Instead of grouping, you could add a column to the source data, and
calculate the week's starting date. For example, if the date is in column A:
=A2-WEEKDAY(A2,3)

Add the WeekStart field to the pivot table, instead of the date.

neat trick - if my data spans 2006 and 2007 I can't find a way to only show
2007 weekly values [since using days + years messes up the "7" grouping of
days].

Any ideas?

Thanks for your reply & assistance.
Jimbo213


:

Use days and set them to 7 that will group like 01/01/05 - 01/07/05


--

Regards,

Peo Sjoblom

 

[Guest]

Excellent trick [ errr ... tip ]

Thanks for your reply & assistance.
Jimbo213

Instead of grouping, you could add a column to the source data, and
calculate the week's starting date. For example, if the date is in column A:
=A2-WEEKDAY(A2,3)

Add the WeekStart field to the pivot table, instead of the date.

neat trick - if my data spans 2006 and 2007 I can't find a way to only show
2007 weekly values [since using days + years messes up the "7" grouping of
days].

Any ideas?

Thanks for your reply & assistance.
Jimbo213


:

Use days and set them to 7 that will group like 01/01/05 - 01/07/05


--

Regards,

Peo Sjoblom



Hello-

I see you can group pivot tables by month, year, quarter, etc..

What happen to 'by week'?

Thanks.