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?