Price comparison in a pivot table

Sat, 22 Sep 2012 10:22:55 GMT

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

topic Price comparison in a pivot table in QlikView

Price comparison in a pivot table