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.
You can use a conditional expression on either the Dimension or Expression that tests the contents of the listbox.
=NOT match(match(listfield, 'myvalue'))
Retrieving data ...