How to "hide" not "exclude" quick filter selection
<p>I need help for selection in quick filters.
When I search how to keep only the value we want to show in quick filters, some source guide how to do it by sets, also another way to do it is by create a duplicate calculated field.</p>

<p>Let's say i have 4 selection in my workbook.</p>

<ol>
<li>Grade A</li>
<li>Grade B</li>
<li>Grade C</li>
<li>Null</li>
</ol>

<p>and they are one in a calculated field named "Grade"</p>

<p>I need to show only "Grade A" and "Grade B". So i made create a set that only contain "Grade A" and "Grade B", let say i called it "Grade - Sets". When the "Grade" variable already on the quick filters, I also put "Grade - Sets" into the filter box. The selection of "Grade" is down into only "Grade A" and "Grade B", however in my workbook it's means that "Grade C" and "Null" are "excluded" from the workbook not "hide". Which means it's affect the calculation, while I want to show the calculation of all Grades but only show "Grade A" and "Grade B" as thr quick filters.</p>

<p>Am I do it wrong? or is there another way to look at it?</p>

<p>Thanks</p>

<p>Randy</p>