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!
Hi,
If there’s date filed in sheet, you could choose the interval by yearly like picture below.
