One selection removing other selections unwantedly
I have a problem where I have made some selections, but on making a further selection it removes some or all of the existing selections. Apparently because applying all the latest selection would show zero results. But that is not a bad thing, I would prefer to see zero results than have other selections removed. Does anyone know how to stop this behaviour?
For example, I may have selected 'Team A' for 'Product Z' for 'Period 1' and a chart displaying a sum of their sales. If I change the period to one where they made zero sales of 'Product Z', rather than showing ZERO, it removes the 'Product A' selection and shows sales of ALL products.