Filtering specific data on a pivot table/chart

[cinstanl]

I am not sure if this can be done, in my mind,"NO" it can't but never the less I have be asked to do this.

I have a pivot table/chart. I can filter by distributors and select all or a few. This effects the view of the area chart, I want it to... however there are two lines on the area chart, they want one of the lines to show the distributor selected and the other to show all. Is that even possible? If I select all it shows all, if I select a few it only shows the few... I am not sure what to do for them or for sure if I am asking this question correctly.

I attached a sample file.

On Sheet two you will find the pivot table and pivot chart... There is a filter at the top, They want one of the lines on the page to show all distributors and all the other data to chose the few that they selected.


cinstanl