Alternate rows color in Cross Table of Webi report
HI,
As per requirement we need to show alternate color in cross table rows as per below screen shot.
We can do the same by below solutions.
Solution 1: With Inbuilt option
Step 1: Write Click on Table, select Format Table then Appearance.
Step 2: In Alternate Color Option, set Frequency and Color as per requirement.
Solution 2: By Creating Conditional Formatting Rule
- Create Local Variable with formula “=Even(LineNumber())”.
- Create “Conditional Formatting Rule” on Local Variable refer below screen shot.
3. At last apply Formatting Rule to Quantity and Value Column and get desire output.
Thanks,
Kashif Ali Khan
If it comes with inbuilt option why you need to explicitly do it 🙂
Please check format Table > Appearance
Yes, we can do the same with in build option also,
Thanks a lot for sharing the knowledge.
Hi Selvarasan,
Blog has been modified as per your suggestion.
Thanks,
Kashif Ali Khan
If the table has columns outside the body, then Table > Appearance > Alternate color will not work.
In this case only the method proposed by Kashif works
Thank you for your valuable knowledge 🙂