Hide Pivot Items based on Filter

[gizzylover]

If I have a pivot table that is filtered on a particular item, how can I then update the other fields (pivot items) to only display the values that apply to the filter? For example, if I had a list of food like:
<br>
Hot Dogs<br>
Hamburgers<br>
Milk<br>
Water<br>

<br>If my main filter was to show liquids only, how could I get the pivot items to hide Hot Dogs & Hamburgers as selectable items in the Pivot Items drop down?