Forum Discussion
Jeremy1565
Sep 16, 2023Copper Contributor
Sort pivot table by dynamic date range
I have two pivot tables that display assessment/training dates in my workplace. I need the table on the left (See image) to display anything that is a "NO" for assessed, and older than 3 months, and ...
- Sep 16, 2023
You might add a calculated column to the source data, with formula
=DATEDIF(date_cell, TODAY(), "m")
Make sure that this new column is included in the data source of the pivot table.
You can then filter this field for >=3 in the pivot table on the left, and for >=24 in the pivot table on the right.
HansVogelaar
Sep 16, 2023MVP
You might add a calculated column to the source data, with formula
=DATEDIF(date_cell, TODAY(), "m")
Make sure that this new column is included in the data source of the pivot table.
You can then filter this field for >=3 in the pivot table on the left, and for >=24 in the pivot table on the right.
- Jeremy1565Sep 19, 2023Copper Contributor
HansVogelaar Thanks heaps, this solved the issue