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

    Struggling to filter in a table


      I have a table that looks like this:



      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.