Subtotais

Calculates subtotals for the columns that you select. LibreOffice uses the SUM function to automatically calculate the subtotal and grand total values in a labeled range. You can also use other functions to perform the calculation. LibreOffice automatically recognizes a defined database area when you place the cursor in it.

Para acceder a esta orde...

From the menu bar:

Escolla Datos - Subtotais.

From the tabbed interface:

Choose Data - Subtotals.

On the Data menu of the Data tab, choose Subtotals.

From toolbars:

Icon Subtotals

Subtotals


For example, you can generate a sales summary for a certain postal code based on data from a client database.

1st, 2nd, 3rd Group

Specify the settings for up to three subtotal groups. Each tab has the same layout.

Opcións

Specify the settings for calculating and presenting subtotals.

Restaurar

Restaura os cambios feitos na lapela actual para os que se aplicaban cando se abriu este diálogo.

Eliminar

Deletes the subtotal rows in the selected area.

Precisamos da súa axuda!