The following discusses the options available on the toolbar of the pivot table view window in Aptify. Options are listed as they appear on the toolbar from left to right. Not all options are available from every field on a pivot table.
Pivot Table Toolbar
Option | Description |
Copy | Copies the information selected. |
Sort Ascending | Sorts the selected field in ascending order. |
Sort Descending | Sorts the selected field in descending order |
Auto Filter | If selected (icon appears indented), an auto filter is applied to the pivot table data. |
Show Top/Bottom Items | Select this icon to display a sub set of items for a selected field. For example, you can displays the top 5 companies or the bottom 1% of persons (based on the order in which items appear within the SQL data set). |
AutoCalc | Provides the user with a list of possible calculations, including Sum, Count, Min, Max. |
Subtotal | If this option is selected, the subtotals display in the pivot table. Subtotals are hidden from view when the option is deselected. |
Calculated Totals and Fields | Use this button to create calculated total and calculated detail fields. |
Show As | Select this icon to display a detail number as a percentage of a row, column, or table total. |
Collapse | If there are multiple rows or columns, this button collapses the selected row(s) or column(s) in the pivot table. |
Expand | If there are multiple rows or columns, this button expands the selected row(s) or column(s) in the pivot table. |
Hide Details | Hides the Details cells for the selected area of the pivot table. |
Show Details | Shows the Details cells for the selected area of the pivot table. |
Refresh | When this option is selected, the data in the pivot table is refreshed from the underlying entity. |
Export to Microsoft Office Excel | Exports the pivot table to an Excel spreadsheet. |
Commands and Options | Displays the Commands and Options dialog for the selected item. |
Field List | Displays the PivotTable Field List dialog box. |
Help | Displays the Help text for Microsoft PivotTable. |