I know you can take a pivot table and create multiple tabs that change by the filtered range. For example in a pivot table you can have a monthly report but you want to show a monthly report for multiple people.
I have a dashboard (an excel page with multiple pivot charts on it), that has multiple pivot graphs and pivot tables on it. I use a slicer to change the filter. So if my slicer is set up for different people, when I select "Johnny" it only shows the info pertaining to Johnny. However I have about 50 people that I want to give these individual dashboard reports to. Is there an easy way, similar to the above to have the reports generate based on that "slicer" filter? Just selecting one pivot table on the dashboard does not do the trick.
I have a dashboard (an excel page with multiple pivot charts on it), that has multiple pivot graphs and pivot tables on it. I use a slicer to change the filter. So if my slicer is set up for different people, when I select "Johnny" it only shows the info pertaining to Johnny. However I have about 50 people that I want to give these individual dashboard reports to. Is there an easy way, similar to the above to have the reports generate based on that "slicer" filter? Just selecting one pivot table on the dashboard does not do the trick.
