1 Reply Latest reply on Aug 15, 2018 5:10 PM by Shinichiro Murakami

    Simple lookup problem

    Matt Wilson

      My data set has three fields: Name, Discount Rate & Week.


      I want the name to populate below the week in which following conditions are met.


      IF [Discount Rate]>3200 THEN [Name}


      The issue is that I don't want the names to repeat in subsequent weeks if the condition has already been met.

      In other words, if John Doe had a discount rate of 3300 in Week 1, and 3600 in Week 2, I only want his name to populate below Week 1.


      The end result should look something like this. It seems like some sort of lookup function needs to involved.