Hi,
I would like to use a date filter on my pivottable that shows only the next 12 months of data. Unfortunaltely the build-in functionality in Excel doesn't seem to include this option. The date filter 'after' is not an option as would have to update the date manually.
I would like to base...