12 Replies Latest reply on Feb 25, 2014 10:37 AM by Matt Lutton

    Using custom groups, filter a viz to only show rows where there are values in all groups

    Jay Chang

      I am sure this is a simple answer but I cannot find the answer using my poor search terms.  I've attached a packaged workbook to use as my example.

       

      As you can see in the workbook, I have a total of three groups - one is a custom group that contains almost every country in the coffeehouse database.  The only members that are not in that custom group are the US and Vietnam.  I'm doing a simple sum of the counts of the various containers in the database.  The thing I'm trying to do is show ONLY those containers that have values in all three groups.  So basically I want to filter out Jumbo Box, Large Box, and Medium box.

       

      How do I do this?