Pivot Date criteria
 

Hi All

I want to put some criteria on "Date" field of my pivot table by
VBA.
Something like = Today(). Is it possible at all ?
Or should I organise my datalist before Pivot accordingly?
Or should I copy my pivot report elsewhere and loop afterwards ?
Any idea ? Thank you very much in advance.

Pivot Date criteria
 

Done it.Works great.

Thank you Jim.


Jim Thomlinson wrote:
Add an extra column to your source data with pretty much that exact formula
in it. You can drag that field to the filter section of your pivot. Each day
just refresh the pivot table...
--
HTH...

Jim Thomlinson


" wrote:

Hi All

I want to put some criteria on "Date" field of my pivot table by
VBA.
Something like = Today(). Is it possible at all ?
Or should I organise my datalist before Pivot accordingly?
Or should I copy my pivot report elsewhere and loop afterwards ?
Any idea ? Thank you very much in advance.