Appreciate your reply on this, however they would like to be able to select the stores they want to exclude from their calculations
I thank your help but I just now managed to find a workaround from this using a context filter approach.
First, I unchecked all the values in the exclude store set. Next, I then went ahead to set the 'Door' field as the context filter and created a new field 'Exclude Door Names'
Fortunately, this approached worked because the set affects all of the 49 fields in the dashboard, hope this solution helps others with the same situation as me.