[pivot table] построение суммарных таблиц гугледоками

some tips to keep in mind when you're building a pivot table report:

• Always organize your data into columns. Column headers become the fields that you add into your pivot table report.
• Google spreadsheets will automatically detect a range of cells for your pivot table. If you don't manually select a range of cells, Google spreadsheets will do it for you. You can edit this data range at any point.
• Drag fields to other categories to change your data analysis quickly and easily.
• You can create multiple pivot table reports from the same set of data. Simply go back to the data source and create a new pivot table report. It will create a new pivot table report on a separate sheet.

читать более подробный help