Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Highlight max min values in a list

Hi experts

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.

Thus:

Store Sales

A 20

B 60 <- best, highlighted

C 15 <- worst, highlighted

D 30

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

Not what you were looking for? View more on this topic or Ask a question