Creating a pivot table

A pivot table lets you summarise a large list without formulas, for example turnover per customer or per month. Excel calls it a PivotTable, and LibreOffice calls it a pivot table.

First make sure your list has headings in the first row and contains no empty rows.

In LibreOffice Calc

1. Click inside your list (or select the whole list including the headings).
2. Choose Insert > Pivot Table.... In the Select Source window, choose Current selection and click OK.
3. The Pivot Table Layout window opens. Your headings are listed on the left under Available Fields.
4. Drag a field to Row Fields (for example Customer), a field to Data Fields (for example Amount) and, if you like, a field to Column Fields (for example Month) or Filter.
5. Double-click the field under Data Fields to choose between options such as Sum, Count and Average.
6. Under Destination, choose for example New sheet and click OK.

Update: a pivot table does not recalculate automatically. Click inside it and choose Data > Pivot Table > Refresh. Modify: Data > Pivot Table > Insert or Edit....

In Euro-Office

1. Click inside your list, and on the Insert tab click Pivot Table. Choose New sheet and click OK.
2. On the right, under Select fields, tick the fields you want and drag them between Filters, Columns, Rows and Values.
3. After changing the list, click Refresh on the Pivot Table tab.

Read more in Pivot tables.

Please note: a PivotTable from Excel keeps working in Calc and Euro-Office, but the formatting may look different. Check the figures once after opening the file and refresh the pivot table.