Conditional Formatting in DMR

[deepak2k2]

Hi,

I'm using Dimensional Model in Cognos 8.4.

I've created conditional formatting with my simple condtion in a crosstab.  But its not working.  Ex:  Crosstab with 4 columns (3 months of data and its average).   Defined a contion as
[Query1].[Revenue]>[Query1].[Avg].

Revenue   Jan   Feb   Mar   Avg
A   10   20   30   20


The above query is not working (comparing 2 data items).  If I compare with static value (revenue>20), then its working.

What was wrong in the query?