Hi All,
I have Quarter column in my data source.
Please find the attached file for the sample workbook.
Better solution and sorry for not thinking of this last night (it was late!):
Drag your relevant date onto the sheet. Then drag it to the Filters pane. You can pretty much click through everything as it doesn't really present the option you want.
Once on there, change the format to Quarter:
Now you must go to the dropdown again and convert to Discrete if it isn't already. After this select "Edit Filter" and you can go to the bottom of the window and select "Filter to latest date when workbook is opened":
This then actually selects the option in the filter as I imagine is desired:
With this you could actually remove the "All" option then if you wanted. Attached for you here as well.
Best,
Bryce
