5 Replies Latest reply on May 18, 2017 9:05 AM by Okechukwu Ossai

    Apply Filter to Future Dates Only?

    Tanya Cashorali

      Hello,

       

      I've attached a sample workbook with data for what I'm trying to accomplish.

      I have counts of patients by country by month. I'd like to exclude a country (filter on the right) so that only counts in future months (Date >= TODAY()) are affected. Therefore past months count of patients shouldn't be changing at all. I've tried adding a condition to the filter but it doesn't affect the counts at all.

       

      Screen Shot 2017-05-16 at 3.09.14 PM.png

       

      Thank you,

      Tanya