Getting Values in Pivot Table

[beetlejuicee]

Hi,

I'am trying to reveal account numbers which have same ip. In pivot table i separated them. Than i counted how many different accounts have same ip. It counts correctly in second sheet but i have to reveal account numbers. How can i do it any suggestion ?


pivot1.jpg
pivot2.jpg

[Glenn Kennedy]

You have attached an image. That's not very easy to work with. We have to re-type your information before we can begin to address your problem. In your case, we can't even do that!! That will put a lot of people off completely.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon