« Data Filtering : AutoFilter | Main | Customizing a Toolbar »
September 29, 2004
DataPilot 101
OOo Calc has a feature that is similar in functionality to the Excel pivot table. It is known as the DataPilot. A whole book could be written on this topic. We will just introduce the concept with a simple example.
Consider the table of data below. There are numerous ways we may want to analyse this data. By using the DataPilot functionality in OOo Calc, we can perform the different analyses quite easily - with a bit of practice.
We first select the table we wish to analyze. Then Data-DataPilot-Start as is illustrated below.
We first are presented with the popup dialog below. We have already selected the data we are interested in - so we just select OK.
The next dialog box allow us to choose the layout of the DataPilot table. In our example, we are interested in knowing how each broker performed in each exchange.
Normally, at least one of the columns in our data source is numerical data that will be processed against the variables we are interested in.
Finally, we get to decide how the data is processed against the input variables. By default, the data is SUMmed, but that may not necessarily always be the case. This dialog is activated by double-clicking on the data field button.
Finally, the output DataPIlot table (or Pivot Table in Excel speak). It isplaced by OOo Calc just below the original data in this example.
We first select the table we wish to analyze. Then Data-DataPilot-Start as is illustrated below.
We first are presented with the popup dialog below. We have already selected the data we are interested in - so we just select OK.
The next dialog box allow us to choose the layout of the DataPilot table. In our example, we are interested in knowing how each broker performed in each exchange.
Normally, at least one of the columns in our data source is numerical data that will be processed against the variables we are interested in.
Finally, we get to decide how the data is processed against the input variables. By default, the data is SUMmed, but that may not necessarily always be the case. This dialog is activated by double-clicking on the data field button.
Finally, the output DataPIlot table (or Pivot Table in Excel speak). It isplaced by OOo Calc just below the original data in this example.
Posted by Dave at September 29, 2004 06:18 AM
Comments
If I wanted to show sum, min, max and average of "Amount" on one datapilot table, how do I specify that? I can do that in an Excel PivotTable, but I have not been able to figure how to do this with Calc.
Posted by: Jim at August 9, 2005 06:36 PM
in the "Select Source" dialog the External Source/Interface is not selectable. How can I use it?
Thanks
Posted by: Tomas at November 22, 2005 07:55 PM