topic Re: Previous year sales for the same weeks in App Development

Previous year sales for the same weeks

campos_rsc — Mon, 20 Dec 2021 21:32:42 GMT

Hi everyone,

I have a bit of a challenge with the following scenario:

Data set is aggregated at a WeekStart Level (lowest level) - I'm deriving the month and year from this date. The user wants to select Year and Month, let's say 2020 - May and see the Sales for last year - same weeks by Product.

So if May 2020 has 5 weeks by WeekStart I would want to show the Sales for the same weeks previous year irrespective of the fact that one of the weeks might fall into June 2019. Remember that only one Year is always selected and Month has one or several months always selected and the final table is made of Product, Sales this Period and Sales Previous Year.

Hope it makes sense, any help would be greatly appreciated.

Thanks

Raz

Re: Previous year sales for the same weeks

usamabinsadiq — Wed, 08 Apr 2020 16:16:18 GMT

Hi Raz,

if you can provide some example data then I think I might be able to help with this.

Re: Previous year sales for the same weeks

campos_rsc — Wed, 08 Apr 2020 23:24:22 GMT

Please find attached.

So again, for the previous year I don't want the Week 18 to be included in the calculation when selecting May 2020.

Thanks

Re: Previous year sales for the same weeks

usamabinsadiq — Thu, 09 Apr 2020 09:48:04 GMT

Please see the result, I think you were looking for this:

Measure Expressions:

//Sales this Period Sum({<Year={$(=max(Year))}>} Sales) //Sales Previous Year Sum({<Year={$(=max(Year)-1)},Week={"$(= '<=' & max(Week) & '>=' & min(Week) )"}>} Sales)

hope this helps,

Regards,

Re: Previous year sales for the same weeks

campos_rsc — Fri, 10 Apr 2020 05:13:55 GMT

Perfect, works as expected.

Thank you, much appreciated.