Forum Discussion
How to filter a Dates in a Pivot table?
From a Pivot Table, how can I filter my data, (date columns) , in a number. I want to say, show the next 10 weeks. I can only do this month, next month, this qtr etc.
Thank you
Dynamic date range filters in PivotTable (next week, last week, etc) are predefined and not work with variables. As workaround you may create calculated column(s) which shows true/false if the date, for example, within next 10 weeks or so. Also relatively static solution with predefined ranges, but they are predefined by you.
3 Replies
Dynamic date range filters in PivotTable (next week, last week, etc) are predefined and not work with variables. As workaround you may create calculated column(s) which shows true/false if the date, for example, within next 10 weeks or so. Also relatively static solution with predefined ranges, but they are predefined by you.
- Perfect, thank you.
Anonxxx , you are welcome
