Hi,
I have a table Name, Date, Income on Sheet 1.
On sheet 2, I have set up a pivot table which will filter the dates of the current month and give me the information.
I have 2 questions:
1. How do I set up the filter so it will always pick the current month?
2. How do I set up the filter so that will still pick the current month even if I delete or clear the information on Sheet 1? So no matter what is will still have the same setting (pick the correct information from the current month).

Is that possible?
Thank you