I'm trying to create a Spreadsheet for work purposes but I can't get it the way I want. If I do it in Excel it works but I can't match it in Google Spreadsheet. I don't even know if it's possible. (See pictures below.)When I filter in Excel, it breaks it down as 2016, 2015, etc. Each year I can click and they have the months in those years. Can this be done in Google Sheets?Google Spreadsheet:Excel (how I want it):
Customizing filter in Google Spreadsheet
google spreadsheets