Can someone help rv02 (who is on London Time)? I'm afraid that I began to approach his solution and I don't know enough about pivot charts to help him in a timely manner. He asked this question two days ago and has not received a proper solution.

rv02 posted an example spreadsheet and he seems to clearly describe his problem. See the following link.

http://www.excelforum.com/excel-prog...in-slicer.html

Thank You