3 of 3 people found this helpful
You can control the context for Show Empty Rows by adding a filter to context. So, in your example, you could create a calculated field with the code:
DATETRUNC('month', [Date]) == DATETRUNC('month', Today())
(where [Date] is the field in your data). The calculation will return true for records where the date is in the same month and year as the current month and year. If you just care about the month (i.e. you want any record for April, regardless the year) then you could use:
MONTH([Date]) == MONTH(Today())
In either case, put the calculated field on the Filters Shelf, select True and then use the drop down menu on the field to Add to Context. Then, you'll get the empty rows, but only within the context of your filter.
Hope that helps!
Thanks so much. So simple yet effective!
You're welcome! Glad it helped!