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
Add the data item the condition is based on to the Row and/or Column edge's list of Properties.
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.
THANKS,
It looks like it make sense, I will test and figure out if it solves my problem.
/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%