only a question.
May I lock the selection filters between sheets.
Filter by date:
First sheet: only year 2015 by sales
Second sheet: year 2014 by weight
The selection filter must not affect other data
in that case all the mesure in your sheet must be built with set analysis and avoid $ caracter so the mesure will not be affected by selection in the menu
Retrieving data ...