Step 1: create a spreadsheet and Pivot table in Libre Office to create
You create in LibreOffice first, a regular table. You can write the data into the appropriate columns (sh. Screenshot).
- Click on a cell in the table and select in the menu bar "data".
- In the open menu, you now go on "Pivot table" to "Create".
- It is the "select source"window opens. Here you leave the selected Option "Current selection". Libre Office recognizes their associated data automatically.
- Confirm via "OK".
Table in LibreOffice
Step 2: Pivot tables-Layout, define
After that, the Dialog "Pivot table Layout" opens. In this case, proceed as follows.
- The Pivot table is initially empty. You will see your available fields in the left display.
- You can now assign the fields to the desired areas. It works by highlighting the field and then in the respective section of the draw.
- In the data fields, usually numeric data to be evaluated. It is, therefore, in the above example, the field "price" is to be classified.
- If you then click "Sum of price" under "data fields", click, you can choose a different function.
- Note that you can enable under "settings" and other options on or off. Here, for example, "blank lines can be ignored" or "categories".
- Confirm via "OK" the creation of the Pivot table.
Pivot table Layout to create
Step 3: evaluation of the Pivot table
Your file will now be automatically added to another spreadsheet. There you will find the Pivot table that you just created.
- If you click above the table to "all", you can take certain data from your table. At this point, is now, by the way, according to the "page field".
- In the example presented here was specified when it was created in step two as the page field of the "camp". You can now about all of the products from the warehouse in Munich, Germany.
- By the data field "price" is calculated in the table are the total price of all selected products.
- You can also remove individual data on the drop-down menus in the row fields from the table.
Evaluation of the Pivot table
This practice tip has been tested with LibreOffice Calc in Version 4.3.4.1. In the next practice tip, we describe the main formulas for LibreOffice Calc.
