Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to crete a bar chart with three rolling years in it so if it is march 2016 it will show back to march 2015 etc.
I have it working when I have current year and previous year data but when I put in the third year I the december figure or most recent figure either doubles or is wrong
the dimension is month and the expressions I have are:
Current year:
=num(Sum({$<CIFCode ={'26.204.18'},ReferredYYYY, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.18'}>}YearMonth), -11))<=$(=Max({<CIFCode ={'26.204.18'}>}YearMonth))"}>}ActualValue)
/Sum({$<CIFCode ={'26.204.15'},ReferredYYYY, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.15'}>}YearMonth), -11))<=$(=Max({<CIFCode ={'26.204.15'}>}YearMonth))"}>}ActualValue),'##0%')
Current year - 1:
=num(Sum({$<CIFCode ={'26.204.18'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.18'}>}YearMonth), -24))<=$(=Addmonths(Max({<CIFCode ={'26.204.18'}>}YearMonth),-12))"}>}ActualValue)
/Sum({$<CIFCode ={'26.204.15'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.15'}>}YearMonth), -24))<=$(=Addmonths(Max({<CIFCode ={'26.204.15'}>}YearMonth),-12))"}>}ActualValue),'##0%')
Current year - 2:
=num(Sum({$<CIFCode ={'26.204.18'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.18'}>}YearMonth), -35))<=$(=Addmonths(Max({<CIFCode ={'26.204.18'}>}YearMonth),-24))"}>}ActualValue)
/Sum({$<CIFCode ={'26.204.15'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.15'}>}YearMonth), -35))<=$(=Addmonths(Max({<CIFCode ={'26.204.15'}>}YearMonth),-24))"}>}ActualValue),'##0%')
Thanks
Just be looking at the expression, nothing seems to stand out. Would you be able to share a sample to show your issue?