1. Is it possible to setup the value of a variable at the SHEET level - I.E I have about 9 displays on the sheet and have 6 such sheets, each of which corresponds to a specific domain, and can be determined from the value of a variable.
2. I also want to be able to display the value of this variable, as part of the 9 displays (graph, chart etc.,) - say in the title or as a water mark.
Here's what I do currently in each of the 9 displays within on a sheet and it works
=Sum({$<PoolName={"COCP"}>} [Total WO]) - I want to know if this can be done at the sheet, and therefore each of the displays inherit this property.
then I want to display this value in the title along with two other dimensions - here's what I have for the title -
