How to add customize date filter in pivot table?

How to add customize date filter in pivot table? Please give a solution.

Thanks,
Shohagh
Manjurul AlamAsked:
Who is Participating?
 
LET (Learn Excel in Tamil)Connect With a Mentor Reporting Automation ExpertCommented:
Hi

Select your data and add insert pivot table, you can have option on row label to do the filter with today, yesterday, last month, current years etc...

And another option select your pivot table, Go to Analyze tab, insert Timeline, image attached for reference
Capture.JPG
0
 
abbas abdullaCommented:
Hi,
If you are using Excel 2013 and above then you can use the Timeline to filter pivot table. For more information access this link Use slicers, timelines and PivotCharts
0
 
LET (Learn Excel in Tamil)Reporting Automation ExpertCommented:
Hope this solution help
0
All Courses

From novice to tech pro — start learning today.