how to highlight the entire row in a cross tab.. I have a column named rank and if its value is 1 then I have to hightlight the entire row corresponding to 1.
I am to able to highlight the rank column using a string variable and setting its background color. but the other cells in the row are not changed.
Thanks,
Nithya
Quote from: nithya1224 on 01 Sep 2014 12:08:23 PM
how to highlight the entire row in a cross tab.. I have a column named rank and if its value is 1 then I have to hightlight the entire row corresponding to 1.
I am to able to highlight the rank column using a string variable and setting its background color. but the other cells in the row are not changed.
Thanks,
Nithya
Hi,
Select the row headings in your crosstab, go to the Properties property, and add your Rank item as a property of the rows.
Then right-click the row headings, choose "Select member fact cells" and apply the conditional style based on Rank using the Conditional Styles button. Choose a type of "numeric range".
Cheers!
MF.
Thanks MF!! It worked
Hi MFGF,
Say I have region name west and products with in it in rows and four measures on column.
Based on my condition if I say if value is >100 green and < 100 red.
The style is applied to all the four columns, is there a way to highlight the background of the region west and the product within it which meets the condition.
Have attached a sample screenshot from Greatoutdoorsales cube.
Here I wanted the background of Camping equipment ,mountaineering equipment , outdoor protection and personal accessories to be also green. Is this possible ?
Thanks,
Nithya