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.