3
Here is a step-by-step guide describing one possible way in which to obtain the result that you require:
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:
Under the PivotTable Tools contextual tab, click on Design and then on Subtotals and select Do Not Show Subtotals:
Select the filter arrow beside the Latest Sum
field, then select Value Filters and finally Top 10...: