Timeline in Pivot Table problem

[Eric Tsang]

Dear all

I am using Excel 2010,

i have a pivot table and need to filter the sales by dates. It is a weekly sales

I noted that in 2013 and 2016 they have a feature - Timeline on the ribbon that iin the "Design"ribbon. which i can not find in 2010.

Can anyone can enlgihted me how to install. ?


Also if this is not working how can i do a "Weekly "group , like quarterly group in Pivot table ??

Thanks
Eric

[Eric Tsang]

Dear all

I have found some information on the timeline
It is super easy for 2013 or above

for 2010 i have to go to option to add-in

Herewith some movie clip on Youtube to share, hope for anyone encounter the same would find it of use

Other references
Group day by week: https://www.youtube.com/watch?v=9QeJxSIADM4

Timeline
https://www.youtube.com/watch?v=zebKmSykYWc&t=95s

You may also want to know
How to Filter Pivot Tables for Month-to-Date MTD Comparisons with Slicers
https://www.youtube.com/watch?v=DGwkAi4hRY4

[aradralami]

Dear all

I have found some information on the timeline
It is super easy for 2013 or above

for 2010 i have to go to option to add-in

Herewith some movie clip on Youtube to share, hope for anyone encounter the same would find it of use

Eric, thanks. The tip in the second video is handy, useful and a time-saver. Thanks, also, for doing some brief Excel version comparisons for certain aspects of the video. I purchased the 2016 MS Office suite licence, recently, but I have not yet updated my existing 2010 installation.