If this is the case then don't show relevant values for Filter2. Show all values in database for for the same and check.
Let us know if you've any question.
1 of 1 people found this helpful
Good morning Grace
Global (and context) filters serve to limit the range of data like a gros filter - if you apply additional filters you are now working on that limited set of data to further refine it - it is like do a series of AND filters - - the one difference is that your global filters are applied to all sheet and your subsequent filters vary from sheet to sheet
If you are trying to hold a view constant at the "Global filter" level you and then see the effect of applying different filters then you can create a sheet with only the global filters applied and another sheet with the global and additional filters applied and bring them together on a dashboard
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.