Need to get only one month data

[bharatkishore]

Hi All,

I have a field called MonthYear starting from Jan 2014 to Sep 2017.

Now my problem is if i select any month in 2017 i need to get only Dec 2016 month data.

The same when i select any month in 2016 i need to get only Dec 2015 month data.

The same when i select any month in 2015 i need to get only Dec 2014 month data

Please let me know if you require anything more.

Attached app for more reference.

Thanks,

Bharat

[bharatkishore]

Thanks a lot... Exactly what i needed thank you so much.

Can you tell me what is difference between Min and Max for the expression...

[antoniotiman]

Max() returns Max MonthYear (sep 2017) when no date is selected.

[bharatkishore]

Thank you....