Forum Discussion
latest value in a series of values.
I want to go from Table 1 to Table 2 using pivot table or other automatic ways to summarize information. What is a good way to accomplish this? I would like to do this in a way that is easy to under...
Create a pivot table based on Table 1.
Add Country, and then State to the Rows area.
Add Rating, and then Date to the Values area.
Click on Rating in the Values area and select Value Field Settings... from the drop-down menu.
Change the summary function to Min.
Click on Date in the Values area and select Value Field Settings... from the drop-down menu.
Change the summary function to Max.
Excel may display the Date field as numbers. If so, select the dates and format as Short Date.
The pivot table should now look similar to this:
Activate the Design tab of the ribbon, to the right of PivotTable Analyze.
Select 'Do Not Show Subtotals' from the Subtotals drop-down.
Select 'Off for Rows and Columns' from the Grand Totals drop-down.
Select 'Show in Tabular Form' from the Report Layout drop-down.
Also select 'Repeat All Item Labels' from this drop-down.
The pivot table should now look similar to this:
