8 Replies Latest reply on Jul 9, 2018 11:37 AM by alex.zapherson

    Return value based on specific criteria

    alex.zapherson

      Data is structured as follows:

       

      Product ID        Seller ID        Price

       

      Product ID 1     Seller ID 1     $2.00
      Product ID 1     Seller ID 2     $1.50

      Product ID 1     Seller ID 3     $1.75

      Product ID 2     Seller ID 4     $20.00

      Product ID 2     Seller ID 5     $21.00

      Product ID 2     Seller ID 6     $20.50

       

      I need to figure out a way to return the price a specific seller (for example the price seller 1 is selling at) for all of the sellers on product 1. Then return the Seller 1 price for all sellers on product 2.  See below for what I would like to have returned.

       

       

      Product ID        Seller ID        Price       Calculated Field (Repeat Seller ID 1's Price for all sellers in separate Field)

       

      Product ID 1     Seller ID 1     $2.00       $2.00
      Product ID 1     Seller ID 2     $1.50       $2.00

      Product ID 1     Seller ID 3     $1.75       $2.00

      Product ID 2     Seller ID 1    $20.00      $20.00

      Product ID 2     Seller ID 5     $21.00     $20.00

      Product ID 2     Seller ID 6     $20.50     $20.00

       

      If you have any questions please let me know, any help would be greatly appreciated, thanks!