Sequencing Weekdays in Pivot tables

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
 
D

Dave Peterson

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.
 
Top