set analysis script into backend load script

vikasshana — Sat, 05 Nov 2022 14:21:15 GMT

Hi,

I've the below set analysis code and now the requirement is to move the code into load script.

num(sum({<MonthDiff={"<12"},AsOfMonth={">=$(=Date(Yearstart(today(),-2),'YYYY-MM'))<=$(=Date(MonthEnd(today(),-1),'YYYY-MM'))"}>}Sales),'#,##0')

Can you help me out how to move this code into load script? Basically here we are calculation 12 months rolling sales.

Re: set analysis script into backend load script

MendyS — Sun, 06 Nov 2022 08:42:32 GMT

create flags in your script,
for example -

TempTable:

NoConcatenate

load *, if (Date>Date(AddMonths(MonthDiff,-12)),1,0)

...

and after that, you can filter more easily