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: Hot Dogs Hamburgers Milk Water 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?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Hide Pivot Items based on Filter

Thread starter gizzylover
Start date Aug 31, 2009
Tags

pivot pivot item

gizzylover

Board Regular

Aug 31, 2009

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:
 
Hot Dogs 
Hamburgers 
Milk 
Water 

 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?