Automatically update pivot table filter

[bossyscores22]

I have a pivot table which includes a filtered date field. The goal is to provide a report showing projected activity for the next month. I can't use the "Next Month" filter since that will include results for the month of May only. I need results from today's date (4/20/15) until the same date in the following month (5/20/15). I'm not concerned about 30 or 31 day months as long as the filter gives me an approximate range of 30 days. Is there a macro that can accomplish this? Thanks in advance.

 

[Fazza]

hi,

If it suits, simplest might be to add a new field to the source data. Field name 'Next_Month' and formula to return TRUE or FALSE. Make this a page field in the pivot table and set to TRUE.

(More complex would be to do this without changing the source data by appropriate SQL to either filter the dataset, or, add a new field like the one just described above.)

OK?