How to sum the value for specific date range?

[gauravgg]

Hi All

I have the following field in a table of data model

ValueType

Budget-FY-16

Budget FY-17

Budget FY-18

May-17

Sep-17

Jun-16

Dec-16

I also have

AmendmentData, ValueType

DD/MM/YYYY, Value

DD/MM/YYYY, Value

DD/MM/YYYY, Value

DD/MM/YYYY, Value

.

.

.

DD/MM/YYYY,Value

when the user Selects Sep-17 from ValueType field  , i want to sum the AmendValue  from starting month of that FY year  till the selected monthYear

(ie from April-17 to Sept-17)

sum(    { ?  }       ValueType  )

Can anyone help me in this?

Thanks in Advance