Comparing independent table calculation results from different sheets

Just as I had finished my blog on how to transfer results of a table calculation from one sheet to another, a new but related question popped up on the forums. This time, the user wanted to compare two independent rankings. I.e. he did not want to compare on a product level but instead he wanted to compare Rank#1 from Ranking A to Rank#1 from Ranking B etc where both rankings could be based on completely independent filters.

Transferring results of a table calculation as a fixed value into another sheet at the example of a Top N ranking

A returning question on the forums is when users want to take the results of filtered table calculation(s) as a fixed value or value set to another sheet which actually is not possible. In this blog post, we will see three option to do the undoable.