Sequencing Weekdays in Pivot tables

  • Thread starter Thread starter lritchie
  • Start date Start date
L

lritchie

I have a set of employee data that records employee timecode & hours fo
each day.

I can create a pivot table to view absenteesim data (identifiable by a
'hours code'.

The hours are accumulated into weekday buckets as follows..

Pivot table layout

Hrs Code -- Mon Tue Wed Thu Fri Sat Sun
SIC 8

DAY 8

DAY 8

SIC 8


Etc...

For each day show hours code and sum of hours...

Our pay week runs Sunday to Saturday...

Problem: How can I control Pivot table day order so that Sumday fall
first, rather than Monday
 
Rightclick on the Code Header
select Field Settings
Click on Advanced
change autosort to manual (if it isn't already)

Then just drag that Sun header to where you want it.
 
Back
Top