Pivot table filter row by today or later

  • Thread starter Thread starter M
  • Start date Start date
M

M

I have a pivot table with dates down the left side row and data in the columns.

I want to filter out any dates that do not occur after today. The key being
that today should be dynamic [such as @now() ] and not have to be manually
reset everyday.

The date filters have various options but none allow use a formula or
reference that is true dynamic.

Thanks for the help,
M
 
Hi

On your source table create an extra column headed Filter.
Use the formula in this column
=A2<=TODAY()

Include the new column in your PT and select TRUE
 
Thanks for your help. That should have been easier for me to figure out. I
appreciate it.



Roger Govier said:
Hi

On your source table create an extra column headed Filter.
Use the formula in this column
=A2<=TODAY()

Include the new column in your PT and select TRUE
--
Regards
Roger Govier

M said:
I have a pivot table with dates down the left side row and data in the
columns.

I want to filter out any dates that do not occur after today. The key
being
that today should be dynamic [such as @now() ] and not have to be manually
reset everyday.

The date filters have various options but none allow use a formula or
reference that is true dynamic.

Thanks for the help,
M
Click to expand...
Click to expand...
 
Back
Top