Forum Discussion

Jeremy1565's avatar
Jeremy1565
Copper Contributor
Sep 16, 2023

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 ...
  • HansVogelaar's avatar
    Sep 16, 2023

    Jeremy1565 

    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.

Resources