How did you know if no year is selected then for which year it should show data. Like you suggested, if April is selected then it should capture data for Apr 2019 not for Apr 2018 or any other year?? Is there any logic behind it?
Great dreamer's dreams never fulfilled, they are always transcended.
- if no month is selected, display data for current month
- if no year is selected, display data for current year
The part I'm struggling with now is when a Year is selected, but no Month selected... and let's just use the example where they choose 2018 as the Year, how do I filter to display data for today's month (April), but from the year 2018 (basically data for April 1st 2018 - April 30th 2018).