Highlight/tag record with lowest value in a sorted group?
I have a basic price tracking database. A quick report enables me to see the lowest price within each group when sorted by type. What I want to do next is set a field within the lowest record in each group to highlight the fact that it's currently the lowest historical price. But I can't figure out how.
The list is quite dynamic, so I would rather not have to run a script each time, but would do so if that's the only/best way to get it done.
A quick example:
Let's say I have three items (A, B and C) with historical prices as follows: A (10, 12, 14, 9, 11), B (11, 9, 10, 11, 11, 12) and C (1, 2, 3, 2) then I would want these to be highlighted in some way: the fourth A record, the second B record and the first C record.
If anyone has a good idea about how to go about this, I'm all ears!