i require VBA to show specific pivot table items based on 1 field critera, and hide if it matches certain criteria of other fields.
Attached is a sample file to achive the following -
if data4 = x or y, then show item.
But if data2 = a, and data1 = data3, and data4 = x, then hide item.
any help would be appreciated.
Bookmarks