1 sheets tagged with "pivot tables":
|
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. |