Add restriction on 1 field which only filter data on one sheet and not on other sheets

[erric3210]

Hi Community,

I've 2 sheets and they both have same 4 filters in it and different charts:

1) Year 2) Product 3) Category 4) Zone

Now, the requirement is:

When user clicks on Year filter in Sheet 2 then the data should filter out

in only Sheet 2 and not in Sheet 1 but if some one clicks on 

Product, Category or Zone filters in Sheet 2 and

Sheet 1 then the data should filter in both sheets.

I'm tying to use Set Analysis in it but it is giving wrong result.

See my approach:

Sum({[Alternate State1]<Area={'North'},Product=$::Product, Category=$::Category, Zone =$::Zone>}Amount)

Need everyone's expert help in this.

Regards,

Eric

[simsa]

You can give sheet action to achieve this: