Is it possible to conditionally format a crosstab table based on a comparison of the CurrentFieldValue and the row total in a crosstab? I am trying to get the fields to flag when they are greater than average.
In this case:
Average of row A is 3.33 - Aug should flag
Average of row B is 1.66 - Aug should flag
Average of row C is 3.66 - June and July should flag
My crosstab looks like this:
description June July Aug Total
A 3 2 5 10
B 1 1 3 5
C 5 4 2 11
In my brain, the calculation should look something like this:
If CurrentFieldValue > Total/12 then crYellow else crNoColor
I can't figure out what the field name of that Total field is.
Please help?