Dear All

I am not sure whether this is possible, however following is what I want to do.

I have a power Pivot table created where it has name of Salespersons and regions and how much they sold. Each Salesperson is responsible to report to specific directors. I have created a report with Macros so that the Directors can select their name and it then they will get directed to a page where they can see the Salespersons they are responsible for. What I want is for them to see all the areas of the Salesperson they choose to see their sales figures, i.e. director X will click on his name and he will get directed to a sheet with the name of all the Salespersons he is responsible for. Then when he clicks on a name it will get directed to another page with only the figures for the areas where that Sales person is operating is showing in the slicer, and not all the values for other sales persons. Then the director can see either the total figures for all the areas where that salesperson is operating or he can choose to see the individual areas for the saales person.

I have managed to do all these ith the exception of knowing how to get the slicer to only have the values shoing for any chosen salesperson on each separate sheet.
I hope this makes sense

any help is appreciate it