Join Data - Calendar - sum(value)

[#1]

Hello,

I have two tables :  calendar and  TABLE_A

In my calendar table, for each date i have field_A

       --> to Monday - Friday field_A= 11

       --> saturday   field_A= 4

date_field      field_A

01/03/2017      11

02/03/2017      11

03/03/2017      11

04/03/2017      4

05/03/2017      0

06/03/2017      11

07/03/2017      11

In TABLE_A, i have 2 dates (begin_Date and End_Date).

begin_Date        End_Date

01/03/2017        01/03/2017

01/03/2017        01/03/2017

01/03/2017        01/03/2017

I want to sum field_A if date_field > begin_Date and date_field < End_Date

Result :

begin_Date        End_Date          field_A

01/03/2017        04/03/2017          22

03/03/2017        06/03/2017          4

03/03/2017        08/03/2017          26

SomeOne can help me ?

Thank you Very much.

Calendar:

LOAD

date_field,

Field_A

RESIDENT Calendar;

TFA_DATA:

LOAD ID,

    begin_Date,  

      End_Date

FROM

FileMars.csv

(txt, utf8, embedded labels, delimiter is ';', msq, header is 7 lines);

[#2]

I put the filter in the last load, sorry and Thank you very much.