Please find the below screenshot and confirm the output. I have also attached workbook (9.3).
Let me know if that helps.
Thanks and Regards,
SampleData.twbx 23.9 KB
I have created a date column using the below formula named as "date" in attached workbook.
Then I have created a filter which will help us to filter the months till selected month in parameter which is named as "Calculation1"
IF [date]<=[ParamDate] then [date]
Thanks Ashish ..
It's very close to what I'm looking for ..
Just a small issue .. Is there a way to make the selector show (07/2016) instead of (07/01/2016) ? The latter gives the impression that the data is upto the 1st of July while the earlier correctly implies that the data includes the full month of July ..
Thanks Rabeeh for closing the thread. This will help other people finding answers similar questions.