I am trying to achieve a functionality where if year is selected then all records having year <= that year should be displayed in straight table and count of distinct IDs displayed in text box.
Also if some year is selected and a particular month is selected let say year selected as 2015 and Month selected as April then all records should be displayed till April 2015 (including all records from all months in Year 2014).
Attached is dummy qvw file with dummy data.
Any help in this regard is highly appreciated.
See also this series of blog posts for an better understanding of analyzing time periods / point in time reporting:
P.S. and you don't need the Monthend() function, that's a relict from a different earlier approach.
Thanks for taking time to reply on my question.
The solution works perfect.
As I can mark only one answer as correct answer I was not able to mark yours as well.