Pivot Tables with the Aggregate Function

An example of using the powerful Aggregate function to achieve a similar effect to pivot tables you might be familiar with from Excel and other spreadsheets.

The first sheet 'donations', is purely data I typed in.

The second sheet is generated using a few lines of post-formula usercode, which invokes Aggregate. This calculates the count, the total and the average donation, all by country.

I used three built-in functions to aggregate the values in the pivot table (len, SUM and AVERAGE.)

It also adds a column to the pivot table which lists the names of all people who donated from a particular country.