Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
PFA sample will help you to arrive the same.
Vikas
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.