Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have data which looks as below
Item Number | A | B | C |
---|---|---|---|
1 | 100 | 300 | 600 |
2 | 200 | 300 | 500 |
3 | 300 | 300 | 400 |
4 | 400 | 300 | 300 |
5 | 500 | 300 | 200 |
I want to have something which says what percentage of the time each shop (A,B and C) is cheapest, so a table which looks like this
Shop | %cheapest |
---|---|
A | 60% |
B | 40% |
C | 40% |
I know you can use RangeMin(A,B,C) to get the cheapest price for each item and could probably do so kind of IF statement to count for each shop whether its prices equals the rangemin but I actually have about 50 shops so that would take a long time
Any help would be greatly appreciated.
See attached qvw
Thanks Gysbert
While this works I also want to be able to select just shops B and C and have the % cheapest recalculated which I don't think this will do.