

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Comparison table
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
well i had to sleep on it
but here is an example of what you want
it uses first sorted value
hope it helps you


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
well i had to sleep on it
but here is an example of what you want
it uses first sorted value
hope it helps you


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Liron, that works for me perfectly!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hei y
so please make this case as answered on so other can know that this question have an answer
