Quote Originally Posted by :) Sixthsense :) View Post
If possible you can allot a helper column in your source data and use formula like the below to determine the required data to get displayed in pivot and use that column in your pivot for filtering data.

=IF(AND(A1>=(TODAY()-30),A1<=TODAY()),"Yes","")
Hey Sixth Sense, thanks for your reply that's a good idea. Unfortunately, I don't have access to the source data since it's all contained on a server and is uploaded automatically. I'll talk to my IT guys and see if we can implement an extra field like this. In the meantime is there anyone that can suggest a method that doesn't involve modifying the source data?