pivot table dates

biglb79

Board Regular
Joined
Oct 17, 2007
Messages
223
I have 52 pay periods that I want to have a pivot table show the breakdown of each week. why can't I have the columns but it breaks it down by year or quarter. I just want all 52 weeks to show
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,706
Still using the Grouping feature, use Days. With Days you can set the day interval to 7. You'll need to specify the first date, or at least a date that begins on the correct day of the week for your weekly periods.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,559
Office Version
365
Platform
Windows
If you right click the date field, select Group by... select Days (and deselect all other time periods) and set the Number of days you can group by weeks.
 

biglb79

Board Regular
Joined
Oct 17, 2007
Messages
223
is that in the field settings for check date, or do I go somewhere else? I have the earnings codes for columns, sum in values and date in rows
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,559
Office Version
365
Platform
Windows
In the pivot table right click the column/row that has the dates you want to group by.

You should then see a context menu with a Group by... option, select that.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,368
Messages
5,468,213
Members
406,572
Latest member
Sidboi21

This Week's Hot Topics

Top