Pivot table filter row by today or later

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
 
R

Roger Govier

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
 
M

M

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter question 2
Pivot table > date filters. Any way to set to most recent days? 1
Pivot table macro filter data between yesterday and today (date+time) 0
pivot table date filters 2
Dynamic date range 1
specify dates in pivot table 1
Pivot Table Filter values 5
pivot tables that combine several data tabs 2

Top