Pivot table date filter

[mart1000]

Using Excel 365

I have historical data on one tab and pivot table in another. I want the pivot table to automatically include date=> today () , but in row filter selection it looks like you cant put arguments like this in?

 

[combo]

Without significant redesign of the underlying data structure behind the pivot table, you can add helper column with formula [tt]=(A2>=TODAY())[/tt] (assuming the column with date starts in A2) and copy down. Resize the range of pivot table data, place the helper column in filters area.

combo