Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can give sheet action to achieve this: