4 Replies Latest reply on Apr 5, 2013 7:27 AM by sarah.wardy

    Filter out rows with 0

    sarah.wardy

      Hi,

       

      I have a list of stores, and for each store a list of products. The "Product" measures are binary: 1 if the product is in the store, 0 otherwise.

      I want to list the products per store (filter out the products that are not in the store).

       

      Any idea about how I can do this for the entire table? I have around 100 stores and products.

       

      I have attached the data file and the workbook.

       

      Thanks a lot!

       

      Sarah.