YTD based on the selection

[#1]

Hi all ,

I want to be able to compare last years data and this years data based on current selections.  Meaning that if I select 2013 and February, I will compare January + February this year against January and February last Year.

Can anyone tell what is the expression for this?

Thanks in advance,

Soumya

[vikasmahajan]

PFA sample will help you to arrive the same.

Vikas

[jagan]

Hi,

Try like this

For Current Year

=Sum({$<YearDimensionName=, MonthDimensionName= QuarterDimensionName=, DateDimensionName={'>=$(=Year(Max(DateDimensionName)))<=$(=Date(Max(DateDimensionName)))'}>}SALES_VALUE)

For previous year

Sum({$<YearDimensionName=, MonthDimensionName= QuarterDimensionName=, DateDimensionName={'>=$(=YearStart(Max(DateDimensionName), -1))<=$(=AddYears(Max(DateDimensionName), -1))'}>}SALES_VALUE)

Regards,

Jagan.