1 Reply Latest reply on Aug 20, 2018 10:44 AM by Jim Dehner

    Struggling to filter in a table

    michael.zehrer.0

      I have a table that looks like this:

       

      table.PNG

      I'm assuming that I am "Ace". I want to create 2 filters that let me analyze how my inventory is gapped from my competitors. First filter would be when I carry a product and my competitors don't. In this example, the filter should show me "White Fridge". Then I want a filter where at least 1 competitor carries an item but I do not. In this example, "Yellow Fridge" would show.

       

      I thought I could tackle it with a calculated field like "Does Ace Carry It?" IF [Competitor]="Ace" and ISNULL([Item]) then 0 else 1 end but this always returns 1, even for yellow fridge. Any help is greatly appreciated.

       

      Thank you.