I have trouble understanding your question. Can you help with this example:
In October, AE, AW, BB, and BD all have less than $100. Do you want all those countries filtered out so the countries aren't there altogether?
If that's the case, you can take what I've attached and just ctrl+drag the dimension on Color into the Filter shelf and select "exclude" for null. I flagged all the >100s.
Amount Spent in Countries.twbx 21.8 KB
A set is the way to go!
Right click Countries in dimensions and create set. In the "Condition" tab, select the radio button for "By field" and use your "Recent Months" calculation in the statement.
Essentially, Sum of Recent Months > 100.
Drop the set you created onto the filters shelf.
See attached workbook.
Hope that helps!
Welllllllllllllllllllllll. Don't I feel silly. That is exactly what I wanted. I swear I tried that and it didn't work. Clearly I was wrong. Thank you so much!!!!