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):
Steps
Author
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.
