Therefore, this setting is used on the rare occasions when the source data is not in the expected (recommended) form.
As mentioned in the requirements for the database, empty rows are against the rules for processing list-like data within a spreadsheet. It is somewhat annoying, that the default setting is not -new sheet -, which is in almost all cases the needed setting.īy using this setting, completely empty rows in the source area will be ignored by the DataPilot. The output position is also exactly defined. This is useful, because it is much cleaner and makes sure that no areas with data are overwritten.The word - undefined – used in this place is wrong and misleading. It's useful instead of using the setting – undefined – to use the setting - new sheet –. If you leave – undefined – and you enter a cell reference, then the DataPilot will show the results at this place. If you do not enter anything, the DataPilot will put your result below the list, that contains your data. Results to defines where your result will be shown. To expand the DataPilot and show more options, click More. As alternative you can use the button Remove. The cursor will change to a crossed symbol. To remove a field from the white layout area just move it with the mouse to the border and let it drop there. For example, if you use the field Employee as a page field, you can filter the shown results for each employee. The summary in your result takes only that part of your base data into account that you’ve selected. Within the branches will be the listing for the different regions.įields that are placed into the area Page Fields appear in the result above as a drop down list.
If you drag for example region and employee into the area Row Fields, the result will be the following: in the vertical direction (row wise), the sum will be divided into the branches. The order of the fields gives you then the order of the sums from overall to specific. There are often more than one field at the same time used to get partial sums for rows or columns. If there are no entries in the row or column fields, then there won’t be partial sums for the corresponding rows or columns. Row Fields and Column Fields indicate in which groups the result will be sorted in the columns and rows. For example, if you move the field sales into the area Data fields, it appears there as Sum – sales. For the data field an aggregate function is used. Advanced users could use more than one field here. The area Data Fields in the middle must contain at least one field.
0 kommentar(er)
