Customize filter application

[#1]

I have 4 Charts with the following fields

Chart 1       YEAR LOCATION ZONE

Chart 2      YEAR LOCATION ZONE NAME

Chart 3      YEAR LOCATION ZONE TITLE

Chart 4      YEAR LOCATION ZONE DEPT

When I apply filter for LOCATION = Houston

I want this filter to be applied only to Chart 1, 2, and 3

But if I apply filter for other fields ie. YEAR, ZONE NAME ETC.. the filter should be applied to all the Charts.  Is this possible?

[Nicole-Smith · Accepted solution]

In your expression on the chart you do not want LOCATION to be included on (Chart 4) you can put the following in your set analysis:

{<LOCATION=>}

So your expression should look something like:

sum({<LOCATION=>} Sales)

This will ignore any selections in the LOCATION field.

[#3]

Thank you very much.