I want to be able to take the current pivot table I have set up, and further sort the data it is importing by date, preferably make it automatically filter out all invoices that are more than 2 days old (for example, if ran today, it would not count any invoice dated 5/12 or 5/13). Is this possible with pivot tables, or is there another way I can go about doing this? It would be even better if the date did not need to be updated every time it is used, and it automatically detected the date 2 days before and filtered that.
Bookmarks