Download "country history sheets" from My Downloads.
Open in MS Excel.
Data >> PivotTable and PivotChart Report...
Use the default settings for PivotTable.
Use President Name for "Row Fields".
Use vCmainTotalPopulation for "Data Items".
Copy these columns.
Paste them off to the side.
Use Employed Army for Data Items.
Remove vCmainTotalPopulation from "Data Items".
Copy this column.
Paste it next to Population off to the side.
Repeat for Total Production Value.
Use Army/Population to find % in Army.
Use Production/Population to find Ppc.
Make it neat with Comma Style values for all columns except % in Army. Use Percent Style for % in Army. Move decimals where appropriate.
Use "Data >> Filter >> AutoFilter" with one of the column beginnings selected. Sort by Population, or