I have a pivot tables (and charts) with slicers. The slicers cut up my pivot tables into day/week/month chunks. I have a lot of pivot tables. The problem... I have to manually update a bunch of slicers every day/week/month.
Let's consider my 'day' slicer. Each morning I update several dozen pivot tables slicers to look at what happened in the previous 24 hour period. How do I make my pivot table do this automatically?
In addition, I just updated my 'month' pivot tables all to display results for the month of March. It took a while. How do I make the pivot table know it needs to only summarize results that occured in the previous month, without me manually updating a bunch of slicers?
Thank You.
Bookmarks