Pivot Table - only show dates greater than =today()

[Angela1979]

Hi everyone,

I am creating a pivot table and need to only show data that is greater
than todays date.
I have tried the following:

Column to filter.
Only include rows where
Date is greater than =today()

This doesnt work, however i am unsure if this isn't working because
the format the date is in is not showing as a date or I am writing the
the above incorrectly.

If =today() should work is there a way I can change the date?
Currently once I have created the report the dates show as
2007/03/12 which I then have to replace / with . and then vice versa
to enable me to format the cell as a date - this could be an internal
problem how the data is set up.

Any advice would be a great help.

Thanks all

 

[Dave Peterson]

How about adding another field to the raw data?

You can use a formula that evaluates to whether the data should be shown or not:

=if(a2>today(),"Show","Hide")

and drag down.

Then build your pivottable, but include this field in the page field. And show
the "Shows".

 

[Angela1979]

Hi Dave,

Thanks for your reply.

The data is external data from an SQL server, therefore I am unable to
edit the data.
Many Thanks

 

[Angela1979]

With reference to the above question:

Could someone please confirm if
=today() should work in pivot tables?