Input column in pivot table

Question

I have created a pivot table from a data set. and what i wanted to do, was to have the pivot table, then add some columns to the end of it where the users can input new data. however the pivot table is significantly long, and if the user filters to one specific object in the pivot table, inputs data in the new manual columns, then removes the filter, the data stays in row 3.

Is there a way i can add these columns to the pivot table so the data stays on the correct rows?

Answer 1

Thank you for your answer. I think what I want simply cannot be accomplished with a pivot table.

Answer 2

No.

Since pivot tables are by their nature changeable in shape as the user moves fields, refreshes from changed source data etc. it is unwise to put data alongside them.

You could copy the values from the pivot table to a separate range and add your additional information alongside that range.  But that may not achieve what you aim to do.