I have a rolling total sorted by most recent date:
DATE - VALUE - RUNNING TOTAL
10/1/2011 - 5 - 5
10/3/2011 - 4 - 9
10/5/2011 - 10 - 19
10/7/2011 - 5 - 24
I have criteria already setup that if my running total exceeds 10, it highlights the row. In my example above, the date 10/5/2011 is when I would be over 10.
I'm using RunningValue to do the Sum and that is working fine, but how can I identify the value of 10/5/2011 in my example and display that in the parent group?