Pivot Table Group by Week?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello-

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

What happen to 'by week'?

Thanks.
 
Simply Beautiful.
Thank you Peo.

Now, can you help with my "Wrap data onto one page" question?
:-)
 
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
 
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
Click to expand...
Click to expand...
 
Excellent trick [ errr ... tip ]

Thanks for your reply & assistance.
Jimbo213


Debra Dalgleish said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top