I'm struck at report level, while drill up from week to months using dimensional model. Initially we showing weeks data(Lowest level) in chart while drill up from weeks to months its not sorted.
months: Jul'2011 May'2011 Jun'2011 Aug'2011 Oct'2011 Dec'2011 Nov'2011 Feb'12 Jan'12 Apr'12 Mar'12
I want show the months : May'2011 Jun'2011 Jul'2011 Aug'2011 Sep'2011 Oct'2011 Nov'2011 Dec'2011 Jan'2012 Feb'2012 Mar'2012 Apr'2012
In databases also same thing we are getting but in report level i'm not getting properly.
Please suggest me anything i need to change in db or report level.