Webi - Compare column values in Cross Tab Report and highlight the row where they don't match

[former_member600842]

I would like to Compare column values in Cross Tab Report and highlight the row where they don't match. Below is the data I have.

[Tom_N8]

Hi Pradeep,

If you mean to highlight non-matching values across a row in a cross table you can do this using Previous() and RelativeValue() functions.

First, create a custom variable "Matching Values Flag":
=If([Value]-[Previous Value 1]) = 0 Then "A" ElseIf([Value]-[Relative Value +1]) = 0 Then "A" ElseIf([Value]-[Previous Value 2]) = 0 Then "A"
ElseIf([Value]-[Relative Value +2]) = 0 Then "A" ElseIf([Value]-[Previous Value 3]) = 0 Then "A" ElseIf([Value]-[Relative Value +3]) = 0 Then "A"

Then, apply a conditional format on your measures:
Non-Matching Values: =[Matching Values Flag] <> "A"

The result would then look like this:

Regards,

Tom