Parameters are not dynamic, they do not update according to new data brought into the data set and they do not get updated based on filter selection. However you can have your parameter drive your filter options. This is what happens in the post that Kumar has linked you to. What you are currently calling a filter in your post could be the parameter instead. Your end-user would be able to select something from there which would then drive other filters within the workbook.
Many thanks for helping me out with the solution.
I provided the below mentioned formula in MY(Month) filter and its throughing me an error message
[Bordereau Month]=[DateParam].Please find the screen shot attached below.
Also i tried
I am getting this error "The formula must be aggregate Calculation or refer only to this field.Please find my Package attached to this email.
Rolling sum.twbx 39.8 KB