Sales selected months last year

[annabergendal]

How can I get sales for selected period last year?

If user selects 2015-03, how can I get sales for 2014-03?

See attached,

Thanks!

[sunny_talwar]

Try this expression:

=If(Sum(Sales) > 0, Above(Sum({<YeasrMonth=>}Sales)))

[annabergendal]

Thanks,

but that does not work.

It gives me previous months sales, not previous year current months sales.

[Anonymous]

For this kind of comparisons, I always calculate a "MonthID" in the script:

(num(Year(Date))-1)*12 + Month(Date) as MonthID

In your expressions you can use afterwards:

Sum({$<MonthID = {$(=Max(MonthID)-12)} >} Amount) for month in previous year

Sum({$<MonthID = {$(=Max(MonthID))} >} Amount) for month in current year

Hope this helps!!

[tresB]

=sum({<YeasrMonth={"$(=Left(YeasrMonth,4)-1&'-'&Right(YeasrMonth,2))"}>}Sales)

[tamilarasu]

Hi Anna,

Try,

sum({<YeasrMonth={"$(=Date(Addmonths(Date#(YeasrMonth,'YYYY-MM'),-12),'YYYY-MM'))"}>}Sales)

!

[annabergendal]

Thanks,

but none of these work for selection of several months.

[#8]

try is

=SUM({<YearMonth={"$(=Date(Addmonths(Date#(YearMonth,'YYYY-MM'),-12),'YYYY-MM'))"}>}Sales)

[Anonymous]

try this:

At script level in your calender table, create this first:

Year*12 + num(Month(Date)) as MonthID

In your expressions you can use afterwards:

=Sum({<MonthID = {'=$(=Max(MonthID)-12)'} >} Amount) for month in previous year

=Sum({<MonthID = {'=$(=Max(MonthID))'} >} Amount) for month in current year

Hope this will help!!

[tresB · Accepted solution]

For multiple months selection try like:

=sum({<YeasrMonth={$(vPreYrMonths)}>}Sales)

where,

vPreYrMonths =Concat( DISTINCT chr(39)&(Left(YeasrMonth,4)-1)&'-'&Right(YeasrMonth,2)&chr(39) , ',')

PFA