![]() ![]() To clear a timeline, click the Clear Filter button. Select the Timeline, then on the ribbon, go to Options > Report Connections, and select the PivotTables you want to include. Provided your PivotTables are using the same data source, you can use a single Timeline to filter multiple PivotTables. Use the timespan handles to adjust the date range on either side. ![]() In the timespan control, click a period tile and drag to include additional tiles to select the date range you want. With your Timeline in place, you’re ready to filter by a time period in one of four time levels ( years, quarters, months, or days).Ĭlick the arrow next to the time level shown, and pick the one you want.ĭrag the Timeline scroll bar to the time period you want to analyze. In the Insert Timeline dialog box, check the date fields you want, and click OK. Much like a slicer for filtering data, you can insert a Timeline one time, and then keep it with your PivotTable to change the range of time whenever you like.Ĭlick anywhere in a PivotTable to show the PivotTable Tools ribbon group, then click Analyze > Insert Timeline. Click Analyze > Insert Timeline to add one to your worksheet. ![]() Instead of adjusting filters to show dates, you can use a PivotTable Timeline-a dynamic filter option that lets you easily filter by date/time, and zoom in on the period you want with a slider control. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |