Hi all, as you'll see from the attached picture I have two PivotTables, both show the details of engineers.
These PivotTables link respectively to two difference reports -- last week's report and this week's report. The only information I'm concerned with in these reports is the engineer's contract end date. A comparison of the two tables will show me if that end date has changed since last week's report.
I need the PivotTable to show only the latest date recorded against an individual engineer's name. As you'll see, an engineer may have more than one contract end date. but for my purposes I only want to be able to see the latest date entered for that contractor alongside their name.
I've tried XLOOKUP and also altering settings in PivotTable (using the MAX formatting) but nothing has so far given me what I need. Does anybody know a solution for this?
These PivotTables link respectively to two difference reports -- last week's report and this week's report. The only information I'm concerned with in these reports is the engineer's contract end date. A comparison of the two tables will show me if that end date has changed since last week's report.
I need the PivotTable to show only the latest date recorded against an individual engineer's name. As you'll see, an engineer may have more than one contract end date. but for my purposes I only want to be able to see the latest date entered for that contractor alongside their name.
I've tried XLOOKUP and also altering settings in PivotTable (using the MAX formatting) but nothing has so far given me what I need. Does anybody know a solution for this?
