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.