How to Create Pivot Tables in LibreOffice Calc

Pivot tables in LibreOffice Calc allow you to summarize, analyze, and explore large datasets interactively without altering your original data. This guide provides a direct, step-by-step walkthrough for preparing your dataset, generating a pivot table, organizing fields, and utilizing interactive features like dynamic filters and drill-down analysis.

Step 1: Prepare Your Data Source

Ensure your data is organized properly before creating the table: * Place unique, descriptive column headers in the first row. * Ensure there are no completely blank rows or columns within the dataset. * Keep data types consistent within each column (e.g., dates formatted as dates, numbers as numbers).

Step 2: Insert the Pivot Table

1. Click any cell inside your data range.
2. Navigate to the top menu and select Insert > Pivot Table (or Data > Pivot Table > Insert or Edit).
3. In the “Select Source” dialog box, ensure Current selection is chosen and click OK.

Step 3: Layout and Configure the Fields

The Pivot Table Layout dialog box will appear. Drag and drop your column headers into the four functional layout areas:

• Filters (Page Fields): Places dropdown filters at the top of the table to filter the entire report by specific categories.
• Row Fields: Defines the vertical categories displayed on the left side of the table.
• Column Fields: Defines the horizontal categories displayed across the top.
• Data Fields: Contains the numerical values you want to calculate. By default, numeric values are summed (Sum).

To change the calculation method (e.g., from Sum to Average, Count, Min, or Max), double-click the field inside the Data Fields area, select your desired function, and click OK.

Step 4: Generate and Intersect with the Table

Click OK in the layout dialog. Calc will generate the pivot table in a new sheet by default.

• Filter Data Interactively: Click the arrow icons next to any row, column, or filter header to select or deselect specific data points.
• Drill Down for Details: Double-click any aggregated numerical value in the Data Fields area. Calc will automatically create a new sheet displaying the exact source records that make up that specific total.

Step 5: Modify or Refresh the Pivot Table

• To Edit the Layout: Right-click anywhere inside the pivot table and choose Properties to reopen the field layout window.
• To Update with New Data: If your underlying dataset changes, right-click inside the pivot table and select Refresh.