Excluding Chart from filters - {1} Isn't working?

[Xzo]

Hi all,

I have a chart with the following set as Dimensions & Measures - I've read through the posts on exclusions and Set Analysis but I cant seem to get it to work.

Dimension = 

=Aggr(Only({1<Site = {'Site 1','Site 2','Site 3','Site 4','Site 5','OSite 6','Site 7','Site 8','Site 9','Site 10','Site 11'}>} Site), Site)

Measure = 

Count({< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))

Is there anyway i can use Set Analysis to exclude this chart from all other filtering on the sheet, if not can anyone suggest another solution/way to do so?

Thanks in advance for any assistance

Steve

[GaryGiles · Accepted solution]

@Xzo 

You need to add the 1 identifier to your measure:

Count({1< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))

[mrdaveBT]

Try this...

Count({1<Status={'3.Due'}>*<Date={">=$(=Date(Today(), 'MM/DD/YYYY'))"}>*<Date{"<=$(=Date(Today()+7, 'MM/DD/YYYY'))"}>} Status)

[Xzo]

I was nearly there! I was putting the 1 in its own set of braces! 

Count({{1}< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))

Many thanks Gary, my headache is over!