This content has been marked as final. Show 3 replies
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.