Hi M Y,
The Points of one player can be compared to all players on one sheet by using a parameter and hiding certain values and pairing it with a window_avg calculation. However, two different filters won't be able to be used. I have attached a sample workbook showing this. Let me know if you have any questions. (The 'hide' dimension of the Show This Player calculation is hidden--go to Analysis>Reveal Hidden Data to see it)
Hope this helps!
Players vs Team.twbx.zip 13.3 KB