Pivot table Timelines

[Len Agnor]

I just upgraded to Excel 2013 and started using timelines. Is there any way to use the choice of dates in another field? For instance, if I choose July in my timeline, could I use that in a title field, "For the month ending July 31, 2016"?

 

[bobhc]

Yes, might want to shorten your title "For the Month ending July 31, 2016"

 

[Len Agnor]

Do you know if the value that is selected has a name that could be added to another field?

 

[bobhc]

No idea, do not know the values you are referring to

 

[Len Agnor]

The value I am referring to is the month chosen on the timeline. For instance if I click on July or August or June-August the pivot table will return all values matching this data. I am just wondering if excel stores that choice (July) in a variable that could be referenced on the worksheet.

 

[Chihiro]

Not without VBA.

For an example if you select "June" you can see start date with following.

    Debug.Print ActiveWorkbook.SlicerCaches("NativeTimeline_Date"). _
        TimelineState.FilterValue1

Which will return "6/1/2016". End date is .FilterValue2 and will return "6/30/2016" in this case.

These values can be set via code in following manner.

    ActiveWorkbook.SlicerCaches("NativeTimeline_Date").TimelineState. _
        SetFilterDateRange "8/1/2016", "9/30/2016"

If you have more than 1 Timeline, "NativeTimeline_Date#" will be the name. Where # is sequential number starting at 1.