Select Data Source

Select the database and the table or query containing the data that you want to use.

To access this command...

Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in LibreOffice.

Selection

You can only select databases that are registered in LibreOffice. To register a data source, choose - LibreOffice Base - Databases.

Select the database that contains the data source that you want to use.

Select the data source that you want to use.

Click the source type of for the selected data source. You can choose from four source types: "Table", "Query" and "SQL" or SQL (Native).