Conditional formatting based on the tuple

[anuhya201]

 Posted by Anuhya (Cognos Developer)
on Apr 14 at 12:02 PM

I have RS crosstab report (8.4 ) on a cube data source and want to apply conditional formatting. I want a conditional format based on the tuple. The tuple is for the Aggregate of regions(row) and the variance %(column). If the variance % is less than the Aggregate value( I have different aggregate values for gross sales, Sales target etc, The aggregare value here refers to the variance %) I need all the values for variance to be in red and if the variance is less than 0(if the variance values are between 0 and aggregate)I need the values to be in yellow.How is this possible? please let me know.

Thanks,
Anu

[anuhya201]

Just to be clear, my report look like this

I am currently working on a Dimensional Model on a cross tab report. This is how my report looks 
   
                                  Current Month                                Quartertodate                                            Yeartodate
                        Grossales Salestarget Variance Variance %    Grossales Salestarget Variance Variance %      Grossales Salestarget Variance Variance %
Div            Region
                                                                      -2
                                                                      -7
                                                                      0 
              Agregate                                           -6
Aggregate
This is how my report looks. I just wanna use the conditional formatting based on the aggregate on variance. Please let me know.

Thanks,
Anu.