Set Monday As First day of the Week

[tester3223]

I created a report which groups sales of my company's product first by the week, then by days.

e.g.
Week beginning: Sunday March,7th,2004
Sunday 7th Sales,
Monday 8th Sales,
Tuesday 9th Sales etc.


Instead of Sunday being the start day of the week, however, I would like to set the start day to Monday.

i.e.
Week beginning: Monday March,8th,2004
Monday 8th Sales,
Tuesday 9th Sales,
Wednesday 10th Sales,
Thursday 11th Sales,
Friday 12th Sales,
Saturday 13th Sales,
Sunday 14th Sales

Thanks in advance for your help!!!

 

[synapsevampire]

Try using the datepart function to create the week grouping:

datepart("ww",{table.date},crmonday)

With your days as a seperate group within.

-k