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?
