Trying to work out how to create a summary sheet for data

[Geogeo]

Hi all,

Hoping you can help what I'm trying to do is create a sheet that will show a basic summary page using the data on the tabs.

On Tab 1 I have IP's with location of where the IP's originate from and the remaining tabs are various sites and IP's we have seen on them.

What I want to do is on the summary page be able to either select the IP's or country and then below for it to display the site they've been seen and and how many seen on that site?

I've attached a test excel sheet of the data layout.

[dilipandey]

Hi Geogeo,

See the attached file where I used pivot table and slicer to achieve the desired scenario
Test Excell.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[Geogeo]

Any way we can get that pivot chart on the summary screen to say which site the ip's have been seen on also?

[dilipandey]

That chart and slicer are already on "summary" screen.

and I am not sure if you are requesting some other point. thanks.


Regards,
DILIPandey
<click on below * if this helps>