If you want a different analysis, just select the drop-down arrow next to the item in the Values pane, then select Value ...

Then, in the Value Field Settings, dialog box, double-click the correct aggregation type to select it and close the window. You can also double-click the field header to alter the number formatting.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

Microsoft's online spreadsheet, Excel Online, ... Still, Microsoft tweaked the PivotTable > Value > Value Field Settings control to add two tabs: Summarize Value By, and Show Value As.