Pivot Table Fields

In the pivot table shown, there are three fields, Name, Date, and Sales.  Name is a Row field, Sales is a Row field filtered by value, and Date is a Value field set to Max.

The Date field settings are set as shown in below. Note the field has been renamed to “Latest” and set to Max:

The Sales field has a Value filter applied to show the top 1 item by Latest (Date):



Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pivot table latest values - 78Pivot table latest values - 51Pivot table latest values - 75