I am trying to create a calculated field in a PivotTable that will capture the max value for the filtered date range.

E.G In this example the column "Sum of Dynamic_Max" would return 526467 for all of its rows. Then when changing the date range it would select the max from the new range and repeat that on all rows.

Thanks In advance.