6 Replies Latest reply on Jan 27, 2017 5:13 AM by Jim Dehner

    How to build a filter or filters with two conditions

    Cathy Chen

      I have 4 years of FCC filings data. I need to separate the customers who had less than 10 filings in any given year in the last 4 years and also had less than 25 filings in total for the total 4 years from the rest of the customers. See the summary table below. Base on the criteria, I should filter out company "BBB" and "DDD". How can I build a filter or filters to get such a result? I am attaching the example file (.twbx) (Version 9.1.0) here. Thanks a lot!!

       

       

      Company2012201320142015Grand Total
      AAA8131224
      BBB594119
      CCC1215 330
      DDD89 724
      Grand Total334651397