0 Replies Latest reply: Sep 22, 2012 6:22 AM by Philippe Motillon RSS

    Price comparison in a pivot table

      Hi ,

      Hope someone can help me :

       

      I have a table containing the following informations

       

      date ,  vendor , city , product , price

      01/01/2012, A , Paris , Prod1 , 100

      01/01/2012, B , Paris , Prod1 , 80

      01/01/2012, C , Paris , Prod 1 , 70

      01/01/2012, A, Paris , Prod2, 120

      01/01/2012, C , Paris , Prod2 , 120

      01/01/2012 , A , Paris , Prod3 , 150

      01/01/2012 , B , Paris , Prod3 , 200

      01/01/2012, A , Paris , Prod4 , 110

      01/01/2012, B , Paris , Prod4 , 70

       

       

      Let say , I select Vendor A .

       

      If I do a graph (pivot table) , it is easy to show per date , city , product  if my prices are better , same price or more expensive than any of the other vendors.

       

      BUT , if I want per city to show that I have (for Paris in that case):

       

      2 products that are more expensive,

      1 which has the same price

      1 which is cheaper than the other vendors

       

      Do you have any idea to do it ?

       

      I want to be able to select on one side who am i (which vendor) and who are the vendors I want ot compare with.

       

      Thanks for your help.

       

      Philippe