group by week in pivot table

  • Thread starter Thread starter Grey
  • Start date Start date
G

Grey

i have design a pivot table in excel, but I found no group by WEEK in the
grouping function...is it possible to do that in other way or let me to
define date of range ???


Million thanksss
 
Right-click on the Date field button
Choose Group and Show Detail>Group
Select Days, and set the number of days to 7
Click OK
 
Just an added tip. The 7 day grouping begins by default with the earliest
date in you table. It could be a Thursday for example. You may want to
adjust both the "Starting at:" and "Ending at:" dates to give you full
"work" weeks.

Dana DeLouis
 
Back
Top