Select 2 options in Pivot Date Filter?

[GigaFluxx]

Under the Date Field Filter settings for my pivot table, it shows "This Year" "Last Year", etc. I can only select one at a time. Is there a way to select both?

I want it to be dynamic too so as time moves one it will adjust so setting a static year will require manually adjusting. I also want to avoid a reference column if possible.


Filter.png

[Richard Buttrey]

Have you tried using the Custim Filter. It should be possible to write a formula that will identify dates > Jan 1 and < Dec 31 of the current year.

Upload the workbook for a more definitive answer. Pictures are rarely much use and no one is inclined to re-create your data when you already have it.

[GigaFluxx]

Sorry, I should have been more specific. The data is from an external source so I can't share it and I don't entirely know the most accurate way to recreate it with the same restrictions.
When I try to use a custom filter it only allows me to enter actual dates and not formulas.

Attachment 661262

[Richard Buttrey]

We don't need to know sensitive data, just take a copy of the workbook and anonymise any personal names or anything else that's private.

Neither do we need evey single row of a large database. Just include a representative sample