How can I compare value of two specific rows from two specific columns?

[AKPWZ]

This question is regarding the paginations, where I want to compare value of two specific rows from two specific columns to proceed further.

I tried to filter out the value and compare using "Filter tool" but not sure whether I can write such expression or not or how to write.

 
Here is the JSON data which look like this: 

And here what I'm trying using the "Filter Tool":

 Thanks!

[PhilipMannering]

Crosstabbing your data is the way to solve this,

[FrederikE]

Your Filter tool is unable to work that way because it only compares values on a row-based level. Filters are not able to compare across multiple rows. 

You could transpose the table to allow certain comparisons following that.

Or you could pre-filter to those two values and then use a multi-row tool to create a flag if this expression is true, then you could filter out the flag. And rejoin the stuff you filtered out earlier.