June 25, 2016
Is there a way to either configure the slicer or create VBA code to run through the slicer buttons or a set number of them?
I have a table of data sorted by weeks. I'd like to automate running through say the last 8 weeks worth to show trend over time. Is there a way to do this?
November 8, 2013
Instead of writing complex codes, the easiest approach is to add a new column to your table, with a simple formula, to create the groups you want.
The formula for this new column should look like:
Refresh the pivot table, and add this new field as a slicer. The slicer will have 2 buttons, one with Last 8 Weeks, and a blank one, for older data.
In this manner, you can create any groups you want.
July 16, 2010
Good idea, Catalin. That reminds me of a post I did to show rolling 12 month periods:
Most Users Ever Online: 57
Currently Online: lebenya monaheng
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas