0 Replies Latest reply: Nov 20, 2015 7:04 AM by Neil Williams RSS

    Comparing Data by months and Fiscal Year

    Neil Williams

       

      Hi,

       

      I'm trying to create a chart that shows 24 months of data, but only compares the last 2 Fiscal years.

      I'm using set analysis in my expression to pull back the previous 24 months work of data based on the month selected. Now I want 1 expression for the current FY, and one for the previous FY.

      I've currently manually put this in simply by adding "Calendar.UKFYYear = {'FY15'}" to the expression, and this works fine.

       

      However, I want to make this maintenance free, and want the "FY15" bit to be calculated based on the month selected.

       

      I have attached the QVW file so you can see what I'm doing.  The expression I'm using is:

       

      =sum({<
      Calendar.MonthName = {">=$(=Addmonths(Max(Calendar.MonthName),-24)) <=$(=Max(Calendar.MonthName))"},
      Calendar.UKFYYear = {'FY15'}
      >}
      Sent)

       

      Any thoughts on how this can be done would be grateful, as I've been playing with this for some time and had no luck.