2 Replies Latest reply: Jun 16, 2010 7:45 AM by ra117hama RSS

    Smallest value per dimension-element

       

      Hi,

      I have the following problem:


      Source-Table is

      Seller | Product | Price

      S1 | P1 | 3.09

      S1 | P2 | 3.29

      S1 | P3 | 6.09

      S2 | P1 | 2.99

      S2 | P2 | 3,49

      S2 | P3 | 5.39

      S3 | P1 | 3.19

      S3 | P2 | 2.59

      S3 | P3 | 6,49

       

      Desired Table with best price per product

      Seller | Product | Price

      S2 | P1 | 2.99

      S3 | P2 | 2.59

      S2 | P3 | 5.39


      How can I solve this? Maybe a question of designing the formula.

      Thanks