Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Group by Week?
Hello-
I see you can group pivot tables by month, year, quarter, etc.. What happen to 'by week'? Thanks. |
#2
|
|||
|
|||
Pivot Table Group by Week?
Use days and set them to 7 that will group like 01/01/05 - 01/07/05
-- Regards, Peo Sjoblom "DTTODGG" wrote in message ... Hello- I see you can group pivot tables by month, year, quarter, etc.. What happen to 'by week'? Thanks. |
#3
|
|||
|
|||
Pivot Table Group by Week?
Simply Beautiful.
Thank you Peo. Now, can you help with my "Wrap data onto one page" question? :-) "Peo Sjoblom" wrote: Use days and set them to 7 that will group like 01/01/05 - 01/07/05 -- Regards, Peo Sjoblom "DTTODGG" wrote in message ... Hello- I see you can group pivot tables by month, year, quarter, etc.. What happen to 'by week'? Thanks. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table Group by Week?
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 "Peo Sjoblom" wrote: Use days and set them to 7 that will group like 01/01/05 - 01/07/05 -- Regards, Peo Sjoblom "DTTODGG" wrote in message ... Hello- I see you can group pivot tables by month, year, quarter, etc.. What happen to 'by week'? Thanks. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table Group by Week?
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. Jimbo213 wrote: 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 "Peo Sjoblom" wrote: Use days and set them to 7 that will group like 01/01/05 - 01/07/05 -- Regards, Peo Sjoblom "DTTODGG" wrote in message ... Hello- I see you can group pivot tables by month, year, quarter, etc.. What happen to 'by week'? Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table Group by Week?
Excellent trick [ errr ... tip ] Thanks for your reply & assistance. Jimbo213 "Debra Dalgleish" wrote: 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. Jimbo213 wrote: 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 "Peo Sjoblom" wrote: Use days and set them to 7 that will group like 01/01/05 - 01/07/05 -- Regards, Peo Sjoblom "DTTODGG" wrote in message ... Hello- I see you can group pivot tables by month, year, quarter, etc.. What happen to 'by week'? Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table - no group on web | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |