New Member
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?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi,
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.
Catalin
July 16, 2010
Good idea, Catalin. That reminds me of a post I did to show rolling 12 month periods:
https://www.myonlinetraininghu.....ng-periods
Mynda
1 Guest(s)