Skip to Content
Author's profile photo Kashif Khan

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

  1. Create Local Variable with formula “=Even(LineNumber())”.
  2. 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

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Selvarasan Subramanian
      Selvarasan Subramanian

      If it comes with inbuilt option why you need to explicitly do it 🙂

      Please check format Table > Appearance

      Author's profile photo Kashif Khan
      Kashif Khan
      Blog Post Author

      Yes, we can do the same with in build option also,

      Thanks a lot for sharing the knowledge.

      Author's profile photo Kashif Khan
      Kashif Khan
      Blog Post Author

      Hi Selvarasan,

      Blog has been modified as per your suggestion.

      Thanks,

      Kashif Ali Khan

      Author's profile photo Gianni Turatta
      Gianni Turatta

      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

      Author's profile photo Vaibhav Singh Rathore
      Vaibhav Singh Rathore

      Thank you for your valuable knowledge 🙂