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.

       

       

      Thanks!