YTD compared to Last YTD

[rcorcoran]

Hi

I have an expression to show Same Period Last Year that works but it only shows the data for the same month as the max month this yr:

=(Sum({$<ReferredYYYY={$(#=only(ReferredYYYY)-1)},ReferredMM={$(#=Max(ReferredMM))}>}ActualValue))

But I now want it to show a sum of the months from the previous year up to the current month of this year - so at the moment we have data from Jan to April 2014 and a year to date column showing the total of the months so I also want a column that will show a total of the months from Jan to April 2013.

When we have data in for May it should then show the total from Jan to May 2013???

Thanks in anticipation

Rhona

[Anonymous · Accepted solution]

Hi, Rhona.

Pleas, try something like this (notice the red parts added to the expression):

=(Sum({$<ReferredYYYY={$(#=only(ReferredYYYY)-1)},ReferredMM={"<=$(#=Max(ReferredMM))"}>}ActualValue))

Hope it helps.

Bruno.

[rcorcoran]

thanks for your help

[rcorcoran]

Thanks Bruno that works fine

Rhona

[Anonymous]

You're welcome, Rhona.

I'm glad I could help.

Cheers.