Hello,

Looking for a bit of guidance with a pivot table - I cant work out on my pivot table how to only display rows where data exists in only 1 column.

So in the attached for example I'd like to be able to change the pivot table to in this case be able to display

Report 1 - Family 1, 4, 5 and 8 (because they have only data in Column East)
Report 2 - Family 7 (because that only has data in Column North)

Capture.jpg


I've tried using value filters but not sure that is the correct solution.

Appreciate any help or tips.

Thanks