Filter lines with Pivot table and non Pivot table columns
 

I have created a pivot table. Next to the pivot table are columns to enter
data and then additional clolumns to add the pivot table and not pivot table
data. I am running a filter on a column in the pivot table, and the non
pivot table data entered does not hold with the pivot table line. (For
example, I have an line in the pivot table (say line 20) call "item 1". I
enter a value in a Column outside the pivot table to correspond to item 1 on
line 20. When I filter on "item 1" - it now moves to line 5; however, the
amount I manually added to line 20 outside the pivot table stays on line 20,
but I want it to move to line 5 with the pivot table data

Filter lines with Pivot table and non Pivot table columns
 

Perhaps you could create a regular table on another worksheet, where you
enter the pivot table items, and the related data in the adjacent column.

Then, on the pivot table worksheet, use a lookup formula to pull the
related data from the table that you created. Link the lookup formulas
to the cells in the pivot table, and they should change when the pivot
table changes.

Grover wrote:
I have created a pivot table. Next to the pivot table are columns to enter
data and then additional clolumns to add the pivot table and not pivot table
data. I am running a filter on a column in the pivot table, and the non
pivot table data entered does not hold with the pivot table line. (For
example, I have an line in the pivot table (say line 20) call "item 1". I
enter a value in a Column outside the pivot table to correspond to item 1 on
line 20. When I filter on "item 1" - it now moves to line 5; however, the
amount I manually added to line 20 outside the pivot table stays on line 20,
but I want it to move to line 5 with the pivot table data


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html