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.