Hi
I am making a list for sites where our company is going to install a device called WatchDog
In the screenshot below, i would like to filter an entire "Koncept nr." out, no matter how many rows the "Koncept nr." consists of, if there is a WatchDog in column D for that "Koncept nr.".
So for example, "Koncept nr." 0326.10 and 0385.10 should disappear, 0394.10 should stay, 0431.10 should disappear, 0438.10 should stay and so on...
But how do i achieve that in a pivot table?
Maybe it's only possible with a formula in the original table?
Bookmarks