1 Reply Latest reply: Jun 1, 2012 1:43 PM by Rob Wunderlich RSS

    Quarter over Quarter Comparison

    Scott Springer

      Please help - I am trying to show a year over year comparison (by Quarter).  I have a chart built that shows spend by Office Location.

       

      I'm using the following to try and determine the total Charges for the selected quarter, or most recent quarter, LAST YEAR:

       

      =sum({$<CalendarQuarterMonthsAndYear={"$(=QuarterName(max(DateInvoice),-4))"}>}ChargeNet)

       

      and the same quarter for THIS YEAR:

       

      =sum({$<CalendarQuarterMonthsAndYear={"$(=QuarterName(max(DateInvoice)))"}>}ChargeNet)

       

      Unfortunately when I select a quarter or year at the top of the QVW I'm getting all kinds of odd results.  It isn't showing the most recent quarter for comparison.

       

      Similarly, I'm using =QuarterName(max(DateInvoice),-4)  as my headers, and those aren't working right either.  When I select "Q4" from a list box it reads "Jan-Mar 2012" instead of "Oct-Dec 2012" like I need.

       

      Please help.  Thank you,
      Scott