Slicers and Extra Columns

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
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,477
Members
414,070
Latest member
DuncanLucas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top