How to calculate sum of last two months in script

[Anonymous]

Hi,

If I have one more dimension (employee), how to calculate sum of two last month for each employee?

Tab:

LOAD * Inline [

Data , Month, Employee

2, 1, a

2, 1,b

4, 2,a

5, 2,c

1, 3,a

2, 4,b

];

Thanks,

Tu Nguyen

[antoniotiman]

Table loaded already sorted.

However, in my script Order By of large table (> 30M rows) lasts 10/15 minutes.

[Anonymous]

Dear Antonio,

Thank you so much.

And kindly need your help on my problem in case having 1 more dimension.

Data:

Load * Inline [

date, sales, outlet

1/1/2017, 1, a

2/1/2017, 1, a

4/1/2017, 0, a

5/1/2017, 0, a

7/1/2017, 1, a

9/1/2017, 1, a

10/1/2017, 1, a

1/1/2017, 0, b

2/1/2017, 1, b

3/1/2017, 1, b

4/1/2017, 1, b

5/1/2017, 0, b

6/1/2017, 0, b

3/1/2017, 0, c

4/1/2017, 1, c

5/1/2017, 1, c

6/1/2017, 0, c

7/1/2017, 0, c

];

[antoniotiman]

I don't understabd Your request,

Which is Your expected result ?

[Anonymous]

Thank you. I found solution, I run inline for every current date.

Thank you so much.