Highlight max min values in a list
I have an issue with query design. The base request I have been given is to produce a report that shows by shop, sales achieved as a list. The request is also to highlight the best (max) and worst (min) performers against all the others.
B 60 <- best, highlighted
C 15 <- worst, highlighted
I have tried Exceptions but this seems to only work for explicit values, not against all the possible values in the list. The report will be automated and the best and worst thresholds will change everytime, so the solution would need to be dynamic.
Thanks in advance.
Using BI 7