Pivot Table help - filter out Columns with data

[CapitalH]

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

[Olly]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.