1 Reply Latest reply: May 20, 2011 8:26 PM by John Witherspoon RSS

    Get quarterly data using the last month of each quarter

      Hi,

      I have a set of data that shows count for each month, example:

      • Jan = 10,000
      • Feb = 15,000
      • Mar = 11,000

      The Quarter 1 data would be the Mar data NOT the sum of Jan + Feb + Mar, so in this scenario, the Q1 = 11,000. The YTD will be Dec data.

      How do I accomplish that?

       

      Thank you so much

        • Re: Get quarterly data using the last month of each quarter
          John Witherspoon

          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.