Show the latest value using pivot table in Excel

Question

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 1

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