Excel Excel 2013 - Control/sync multiple slicer timelines from one slicer timeline

BaseLine9

BaseLine9

Joined
May 10, 2005
Messages
190
Reaction score
0
Hi

I have two pivot tables and I want to be able to control date ranges in those pivot tables with a timeline slicer. The problem is I want to control them based upon different dates (Different fields in the raw data). So I want to select 01/01/2016 based upon date1 in one pivot and 01/01/2016 based upon date2 in another pivot.

I can have 2 slicers but the user will only want to click one. I think the solution would be is to have one master timeline slicer showing and then one in the background/hidden that also changes when the master timeline slicer is changed. I think this could be possible via VBA?

Once I have done this for two dates then my aim is two extend it out to more

I really hope someone can help
icon_smile.gif


I'm on XL2013

Many thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 Slicer Connection / Pivot Table Problem 3
Excel, assign cells in multiple worksheets from one sheet 1
Sum values in a "chronlogical date list" from "transactions table" 5
grouping multiple tables Excel 2007 3
Combining Records Based On Certain Dates- PLEASE HELP 6
combining table data 2
Excel Excel prob. with two series on one line chart 6
multiple records from one 1

Top