Conditional formatting based on column NOT present in crosstab

[MellBI]

I try to make a conditional formatting in a crosstab and do not want to show the column that the formatting is based on.
The best try i have managed to implement is to include the column but delete borders and use a font that is not visible.
BUT the column width is not possible to adjust to 0 or 1 pixel so it is actually visible anyway => report takes up to much space in width.

Anyone with similar reports that have solved this in a decent way?

MellBI

[rockytopmark]

Add the data item the condition is based on to the Row and/or Column edge's list of Properties.

[raro]

compiled a short primer on conditional formatting of crosstab cells without its base beeing present in the crosstab itself. have a look at: http://www.zeitfenster.de/cognos/C84_How_to_format_a_crosstab_in_Cognos_8.pdf

comments welcome.

[MellBI]

THANKS,

It looks like it make sense, I will test and figure out if it solves my problem.

/MellBI

[MellBI]

I did not manage to apply this to my report.
I was not allowed to assign a measure as a attribute to another measure and the Boolean variable only gives me 2 situations when I need at least 4.

I have
Columns: Years with four measures inside every Year.
Rows: Two nesting levels

The colour of the font in one of the columns (Measure 1) is supposed to be different depending on a calculation based on measure 1 and one measure that we do not want to present, measure 2. (Measure 1 / Measure 2)
Based on a scale like: Blue if > 85%, Green if >=75%, Yellow if >=50%; Red if < 50%