0 Replies Latest reply on Feb 27, 2012 8:43 AM by Todd Snell

    filter by a group count

    Todd Snell

      Hello All.  I have a set of purchase information by customer at a detail level and need to find a way to filter customers who haven't purchased more than x number of units.  I can do this with a condition filter easily enough, but ALSO need to use that same field to filter certain customer names by selection.  Here's an example:

      Customer NameNumber of Records
      Customer A1
      Customer A1
      Customer A1
      Customer B1
      Customer B1
      Customer B1
      Customer B1
      Customer B1
      Customer D1
      Customer E1
      Customer E1
      Customer E1

       

      I'd like to filter this so I only show customers who have more than 2 records, AND I also want to exclude "Customer E", which leaves Customer A and Customer B.

       

      What is the best way to accomplish this?  Again, I could use a condition filter, but I'd really rather write a formula if possible to identify those who have more than two units, but do a global filter to exclude certain names.

       

      Thank you!