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

    Filter out rows with 0




      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!