filter pivot table by last two days

[avandever]

I have a pivot table and one of the columns is named "prmdt." What I want to do is whenever I run my macro to automatically update the report, I would like it to only select today and yesterday in the "prmdt" column. In the past I believe I have ran into issues when I run the report multiple times, clearing the previous filters and re applying the new ones. Thanks.

 

[Fazza]

hi,

One way. Create the pivot table in a new workbook using the external data option at the first step of the pivot table wizard. Follow the wizard to the end choosing the option to edit in MS Query. (Resultant worksheet can be moved into a different file if you like, for example the source data file.) Edit the SQL to suit. Say like below, or some variant. Then each time the pivot table refreshes, you only have the data of interest.

regards

SELECT *
FROM YourData
WHERE CLng([prmdt.]) IN (Date -1, Date)