I have the following expression that is in for each month of the year in a chart and it shows a cumulative figure for the Pall Specialist. This one is the expression for April and will show Jan feb, march and April added together.
My problem is that I need to have a column with the Same Period Last year. I normally show this by doing the second expression below but I can't get it to work for the cumulative SPLY which should show Jan- to April here if april is the max month.
if(num((((Sum({$<[PallCare Specialist]={17},ReferredMM={4}>}ActualValue)))), '##0')>'0',num((((Sum({$<[PallCare Specialist]={17},ReferredMM={1,2,3,4}>}ActualValue)))), '##0')))
num((((Sum({$<[PallCare Specialist]={17},ReferredYYYY={$(#=only(ReferredYYYY)-1)},ReferredMM={$(#=Max({<[PallCare Specialist]={17}>}ReferredMM))}>}ActualValue)))), '##0'))
Any help would be appreciated
rhona