Re: Get quarterly data using the last month of each quarter
Define your quarters that way, and the charts will follow. Generally speaking, applications would have a master calendar table in them. This table would have a quarter. Normally, you'd define a quarter for every date in the calendar. In your case, only define the quarter for the last month of each quarter. For example:
if(mod(month(Date),3)=0,quartername(Date)) as Quarter
The exact expression will depend on how you want your quarters to look, though.