YOY analysis

[raju_salmon]

Hi Experts,

I have a requirement where i should compare past 12 months (based on today day ex: Today Jul4th 2017 so Jul 2016-Jun 2017 - 12 months) with past to past 12 months (means Jul 2015-Jun2016) and it should dynamic.

Can any tell me how can i consider this using YearToDate or InYearToDate function? Month will be my dimension.

Thanks,

Raju.

[MK_QSL]

You need YearMonth or MonthYear as Dimension

Expression

RangeSum(Above(SUM({<MonthYear>}Sales),0,12)) * Avg(1)

Make sure that you have sort order Ascending on YearMonth or MonthYear

[raju_salmon]

Hi,

Dimension is only month. Charts shows 12 months (12 bars) each bar compare data between two months (this year vs last year)

[sunny_talwar]

May be this

This Year

Sum({<Year = {"$(=Max(Year))"}>}Sales)

Last Year

Sum({<Year = {"$(=Max(Year)-1)"}>}Sales)