Filtering in pivot table

[mureren]

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?

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[mureren]

Thank you for that....i am looking in to Power Query (my first attepmt with that!), but if that does not work out i will get back with a uasble attachment.

[AliGW]

We can also help with PQ.