sort by month

[#1]

HI,

I have a pivot table that has calendar week and weekday as dimension and then 3 formulas that show the date from selected date for the years 2010, 2011 and 2012. I want to sort my chart now by calendar week. it is not a problem from Feb-Nov cause there are no dates from the previous year. (I always show complete caledar weeks meaning from monday to sunday so if a month started on wedensday I'm still showing monday and tuesday from the previous month) so my problem now is if I sort by calender week ascending I have in january the 52 week at the end even though I need it at the beginning and the in december I have the first week at the beginning even though I need it at the end.

I tried sorting by formula (date) but qv doesnt sort it at all.

does anyone have an idea how I could solve this problem?

regards,

MT

[chematos]

You should modify your calendar, create an OrderWeek that always week 1 starts on January and ends on 52/53 on December.

I had to make a calendar with sundays as first day of week, for example, things like this simplify the expressions a lot.

hope this helps