2 Replies Latest reply on Aug 21, 2018 8:14 AM by Ben Neville

    How to use column filters in Tableau

    Steven Cunden

      Hi,

       

      I have an excel sheet with some store number in one column, labeled "Store Num", and sales data in another column, labeled "$". I have another column labeled "Matched" where each row is either a 0 or a 1, depending on whether the Stores match the ones we have in our database. Store 50 for instance will have a 0 match, because its not one of out store, as opposed to store 123 that will have a 1 under "Matched."

       

      When I want to plot the $ sales of only the matched stores. In excel, i can just add the "Matched" column as a filter, and select only those that have a 1. How can i do the same thing on Tableau?

       

      Thanks