Pivot tables allow you to very accurately retrieve data for easy analysis, to help you compare and interpret figures, and to enable you to make informed decisions. Using an almost infinite number of options, you can define the data set required to give you an overview of the information you need. You can add data, such as columns showing averages or totals, where required. You can also choose how the data should be presented, for instance by applying a sorting method or a number format. The ability to specify your own data selection, calculation method, and presentation method will simplify the interpretation of your data.
The pivot table displays the data from the List tab that are present at the time the pivot table is activated. The number of records and the available columns depend on the presets, filters or multiselect actions that may have been applied.
Pivot tables can be created:
Rights governing the use of pivot tables
In order to be able to use pivot tables, you need rights to the entry form from which you will open the pivot table, as well as to the pivot table analysis (program code 100009991). If a user has no rights to pivot tables, but still needs access to one or more pivot tables, you can grant this user access in the relevant preset settings. To do so, use the Presets form to select the Allow pivot table check box. If a user without rights to pivot tables needs access to one or more pivot tables while working in reports, you can grant this user access to the relevant report form.