When subtotaling a column based on a field change in another column can Excel
also calculate percentages for each value that makes up the sub total.