set analysis script into backend load script

[vikasshana]

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.

[MendyS]

@vikasshana 

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