Thanks Jim, am closer to what am after for some reason with the actually data am getting wee bit different results.
I can highlight the end of the line no problems just want to highlight the top 1 and grey the rest as my view in the actually data got hundreds of lines.
Compute using the staff id getting me closer.
Guess what am doing is to say
- Find highest running total end point so the last index
- Then I want to highlight all the index for that line
I tried to use LOD however that doesn't work as got table calculations unless and messing something.