select gray field (unavailable field) override other selections
Hi, I have a problem of retaining my filters after click an gray (unavailable )field, it actually will override my previous selection
What I doing is:
In my Claim report
I select Agent (which only have claims in 2013 and 2014), so in Year listbox only 2013 and 2014 are white (available) and other years gray out. My problem is I can still click those gray-out year, this will override my previous selection of Agent. It will show claims of All Agent in this year.
This will make confusion. I' d like always maintain the previous selections. and if by chance clicked gray field, it will show either 0 or unavailable, Is there way to do that? I dont what use 'Hide Excluded". Because by using that, if i select 2014 , then year 2013 will hide too, so I will not able to switch from 2014 to 2013.