The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
Hi Folks
I'm using Excel 2013.
I have 12 countries that are in a slicer.
The pivot table contains Customer data i.e. name, invoice number, amount etc...
Now what I have done is to add extra columns to the end of the data which is the Account Manager's feedback.
When a country is selected from the Slicer, the data is limited to that country (as expected).
The account manager then selects his/her customer and enters their feedback, for example row 23.
Now when the Customer/Country is deselected, the pivot table is re-populated and the feedback remains in row 23 when it should have moved row 40 as that is where the customer is now.
I understand that the additional columns aren't linked to the pivot table in anyway - any idea's on how to link it?
Appreciate your thoughts/help!
Cheers
I'm using Excel 2013.
I have 12 countries that are in a slicer.
The pivot table contains Customer data i.e. name, invoice number, amount etc...
Now what I have done is to add extra columns to the end of the data which is the Account Manager's feedback.
When a country is selected from the Slicer, the data is limited to that country (as expected).
The account manager then selects his/her customer and enters their feedback, for example row 23.
Now when the Customer/Country is deselected, the pivot table is re-populated and the feedback remains in row 23 when it should have moved row 40 as that is where the customer is now.
I understand that the additional columns aren't linked to the pivot table in anyway - any idea's on how to link it?
Appreciate your thoughts/help!
Cheers
