Sequencing Weekdays in Pivot tables

[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

 

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