Hiding rows in a flat table where two values are not equal

[elijahabel]

I'm working on a problem where we need to check where values from different environments do not align.

I have a flat table with the below  columns

UAT.Division     |      Prod.Division     |     Sum(UAT.Value)    |      Sum(Prod.Value)

I want to only show the rows where  Sum(UAT.Value)  <> Sum(Prod.Value).

How can I accomplish this? Thank you!

[JustinDallas]

Hmmm, generally, you can use an "If" statement in the Dimension declaration.  But the problem here is that you have the aggregate function (Sum) as your criteria, and QS isn't going to like that.  I'm interested in what the solution you settle on will be.