Set analysis: exclude all except 1 dimension + set 1 dimension
After scouring the community, I still can't get this to work - any and all ideas would be appreciated!
Requirement: always display a specific KPI (Alias=CTR130) for a specific year (set in a variable called vCY). The result should NOT change when selections are made, except where the user makes a selection in one dimension (Entity Name).
I can sucessfully get the following script to work: