Hide field in Pivot table chart when selected a specific value in list box

[Anonymous]

There is a list box and there is a pivot table chart object.

Scenario is: I would like to hide the filed in the pivot table when I select a value in the list object, pl help.

[rwunderlich]

You can use a conditional expression on either the Dimension or Expression that tests the contents of the listbox.

=NOT match(match(listfield, 'myvalue'))

-Rob