YTD based on date selection for each month in the year of selected date

[jeevays7]

Date               MonthYr         Value

30-Dec-2016  Dec-2016          100

1-Jan-2017     Jan-2017          10

3-Jan-2017     Jan-2017          11

1-Feb-2017     Feb-2017          20

10-Feb-2017    Feb-2017         30

1-Mar-2017     Mar-2017          60

The above is my data and i need,

If i select a date i.e. 1-Feb-2017, the result should show value from year start  to end of the month of selected date.

result should be like below,

MonthYr     Sum(Value)

Jan-2017     21

Feb-2017     50

and if i select a date i.e 30-Dec-2016 the result will be,

MonthYr     Sum(Value)

Dec-2016     100

[sunny_talwar]

Is MonthYear pivoted in your pivot table? May be this?

RangeSum(Before(Sum(Sales), 0, MonthNum))

[jeevays7]

Thanks a lot sunny.

Now its working fine.

My problems are fully solved. thank you very much.