![]() In Database Explorer, select required tables from the Sakila database and drag-and-drop them to the query document. Open a query document by clicking the New Query icon on the Devart - Main toolbar to select it as a data source for a pivot table. You should place data source fields from the Data Source view into the pivot table areas to add the data to the pivot table.Ĭreate a pivot table using a query file retrieving four three columns from the Sakila database.Īs the original Sakila database contains a huge number of table records, they were cut down to half to illustrate the example.Īnalyze which film category had more rentals and brought the highest revenue in each particular month. The data source should contain a column with duplicated values, which can be grouped, and a column with numeric data, which can be used to calculate grand totals and custom totals. ![]() Not all the data source tables are good for converting into a pivot table. The data source can be a query in the SQL or query document. You should connect a pivot table to the data you want to display and rearrange in the pivot table. You can create pivot tables using the pivot table view of the SQL document. Pivot table is a table that allows you to easily rearrange or pivot your data by a simple drag of a mouse until you get the layout best for understanding the data relations and dependencies. This topic describes how to create pivot tables and efficiently analyze data using pivot tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |