3 Replies Latest reply: Feb 15, 2012 9:50 AM by Liron Baram RSS

    Comparison table

    Yavor Atanasov

      Hi all,

      I need fresh ideas on the following problem (please see the attachment):

      I have list of prices from different companies for products (multiple prices for 1 product possible, because of partner companies, etc).

      I want to count the number of times a competitor price is closest to my price where my price is best (rank 1).

      But sometimes my company (partner) gives second best price as well, so I have to count third best price as a closest competitor one.

       

      In the attached example I'm able to achive this when a product is selected. Table Closest Competitors would show what I want.But I don't know how to show the overall numbers.

       

      Any ideas are welcome and much appreciated.

      Thanks

      Y