Creación de táboas dinámicas
-
Coloque o cursor dentro dun intervalo de celas que conteñan valores e cabeceiras de fila e columna.
-
Escolla Inserir - Táboa dinámica. Aparece a caixa de diálogo Seleccionar fonte. Escolla Selección actual e confirme con Aceptar. As cabeceiras de táboa aparecen como botóns na caixa de diálogo Táboa dinámica. Arrastre estes botóns como precise e arrástreos para as áreas «Filtros», «Campos de columna», «Campos de fila» e «Campos de datos».
-
Arrastre os botóns que precise para unha das catro áreas.
Drag a button to the Filters area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter.
If the button is dropped in the Data Fields area it will be given a caption that also shows the formula that will be used to calculate the data.
-
By double-clicking on one of the fields in the Data Fields area you can call up the Data Field dialog.
-
Use the dialog to select the calculations to be used for the data. To make a multiple selection, press the CommandCtrl key while clicking the desired calculation.
-
The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse.
-
Remove a button by dragging it back to the area of the other buttons at the right of the dialog.
-
To open the Data Field dialog, double-click one of the buttons in the Row Fields or Column Fields area. Use the dialog to select if and to what extent LibreOffice calculates display subtotals.
Exit the Pivot Table dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Filters area. The pivot table is inserted further down.
