The only way to steadily get summary data for further processing is to use formulas instead of a pivot table.

The recently introduced functions PIVOTBY and GROUPBY can help you as well as other functions already available for the years.