AnsweredAssumed Answered

Highlight/tag record with lowest value in a sorted group?

Question asked by gwjfyo on May 7, 2011
Latest reply on May 7, 2011 by gwjfyo

Title

Highlight/tag record with lowest value in a sorted group?

Post

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!

Thank you.

Outcomes