Pivot Table filter by Calendar Year

[user452]

Hi, does anyone know if the pivot table can be created and filter the data by each calendar year? I’m trying to create a report to manage annual leave for each employee. Thanks!

[hank]

Hi,

If there’s date filed in sheet, you could choose the interval by yearly like picture below.