Alternate coloring based on a characteristic

[former_member212706]

Dear Experts,

     We have a reuirement for having alternate colors for rows based on a characteristic. For eg. I have a candidate and his hobbies as listed below.

Please let us know if this is achievable and a way to achieve this.

Thanks,

Rajesh

[Former Member · Accepted solution]

The following Post will surely help you.

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/11/11/alternate-row-colors-i...

You can take the basic Idea From here

Hope It helps 

[former_member189638]

Is your Candidate a Number or String?  If it is string then first convert it into number and use it in the Rule Formula else if it is numeric then use it as it.

Assuming it is string

Goto Analysis -> Conditional -> New Rule. From the Condition Drop Down select Formula Editor and put the below formula.

=MOD(TONUMBER([CANDIDATE]);2) =0

The click on Format and select Background and select the Color

Similarly Create one more rule with the formula

=MOD(TONUMBER([CANDIDATE]);2) <> 0

Select a different color for this.

Now click on the table columns and select Formating Rules and tick both the checkbox of Rule1 and Rule2 so that they are active on the table.