Show the latest value using pivot table in Excel

I have this table

and I want to get the latest -by date- "latest Sum" value of every "From". I expect something like :

2018-02-03 | person1 | 9200
2018-02-05 | person2 | 2600

I created a pivot table but apparently I made something wrong. Here it's what I got

I want it to show only the latest date

Answer

Here is a step-by-step guide describing one possible way in which to obtain the result that you require:

---

1. 
   

   I've started with your current setup:

   
   

   A table containing the relevant data, and a pivot table created using the default options, with the From and Latest Sum fields as Row Labels, and the Date field as a Value, with the Value Field Setting set to summarise the Date field using the Max function:

   
   

   

   
   

   This configuration yields a pivot table as shown in your question:

   
   

   

   
   

---

2. 
   

   Under the PivotTable Tools contextual tab, click on Design and then on Subtotals and select Do Not Show Subtotals:

   
   

   

   
   

---

3. 
   

   Now click on Grand Totals and select Off for Rows and Columns:

   
   

   

   
   

---

4. 
   

   Now click on Report Layout and select Show in Tabular Form:

   
   

   

   
   

---

5. 
   

   Select the filter arrow beside the Latest Sum field, then select Value Filters and finally Top 10...:

   
   

   

   
   

---

6. 
   

   Configure the Value Filter as follows:

   
   

   

   
   

---

Final Result