I approached it like this. I used superstore sales as an example. I Created a calculated field: "Order Date (Date Only)"
Then another caculated field: "More than 11 months since last order"
DATEDIFF('month',MAX([Order Date (Date Only)]),TODAY()) > 11
I used those both in the attached workbook and then hid the values when "More than 11 months since last order" = false.
Hope that helps!
No orders in last 12 months.twbx 410.8 KB