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

Question

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!

FrederikE · Answer

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.

philipmannering · Answer

Crosstabbing your data is the way to solve this,

compare-pages.yxmd