Highlight expression within a range of criteria

[triciagdaly]

I am needing to highlight an expression that's already sorted, and wanting the least 10 and greatest 10 values highlighted.  Attached is the expression definition, and a screen snippet.   Any help is greatly appreciated!

Thanks!

[maxgro]

maybe with rank?

see attachment

[triciagdaly]

I will need an explanation to this example, with emphasis on understanding why there are duplicate expressions, along with how the rank fields appeared in the Presentation.    You have listed a TransLineID.  Is this critical in getting this to work?  Having a unique identifier for each row?  If yes, maybe using rowno().  Am not able to duplicate your example in my scenario.

[maxgro · Accepted solution]

You can disable or remove my first expression

For rank field see image; I used rank(expression) for greatest and rank(- expression) for leatest

Regarding TransLineID, unique identifier: I think there is no need of an unique identifier, see second chart in the attachment  (2 dimensions, rowno(total ....))

[#5]

Thanks very helpful.