Hi Gurus

Tried to search here for the familar cases, but did not find anything which suits my needs, so I do hope that someone can drop a hint. I'm trying to create the formula which calculates the maximum value for each column in crosstab. Cross tab looks like :

             2001 2002
John I     15      14
John II    20      18
John III   18      19

So, here I have 2 columns and the goal is to add red background if the current value is the maximum value of the column. In this case 20 for 2001 and 19 for 2002.

I tried to use the following syntax if currentfieldvalue=maximum(value,group) then crRed else NoColor; then it calculates the max value for the first year only, is there a way how to achieve this for each year?
I tried to implement something familiar to this one: http://www.infosol.com/buildpage.aspx?k=cr_tt15 but it does not seems to be my case.

Thanks in advance, PV