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?
Excel (how I want it):