Hi,

I have a pivot table summarizing a large subset of network traffic (source ip/destination ip/port) I would like to send this pivot table to users so they can acknowledge whether the traffic is needed or not needed. I'm running into a few issues with this:

1) I tried to add a blank column, with column header of Yes/No, on my raw data sheet, however I'm not able to edit values within the pivot table.
2) I started a new column next to the pivot table, however the values of the column don't collapse when I collapse the rows of the pivot table.

I'm aiming to get something close to the attached. The Yes/No will be filled in by the user(s).

Capture.JPG

Any help/guidance would be much appreciated!