If you are interested in a simple table that allows you to get the count or sum of all the elements in your view according to the Field that you selected for the 'Pivot by' then the Pivot Table is the right view for you. The main value of the Pivot Table from comes, you guessed it! its pivot capabilities. You can select from any available fields to get the exact count or sum of the records available.
Edition Qualifier: Pivot Table is available in all FreeAgent Editions.
User Permissions: No special permissions are required to use Pivot Tables.
Pivot Table Configuration
To customize it, click the 'gear' icon next to the 'Save View' button. Select the columns you want to see and uncheck the box for those you don't need.
| CONFIGURATION | DESCRIPTION |
| Pivot By | Select the field used to organize the data in the chart. |
| Aggregation Count | Displays the total (count) of values according to the pivot field. |
| Aggregation Sum | Adds the values of the selected aggregation field. Only currency or numerical fields are available for this aggregation type. |
| Pareto | If you enable it, the bars in the chart will be rearranged automatically starting with the biggest value. |
Manage Data
You have multiple options to handle the data displayed in your Pivot Table.
Delete Row
To remove a row from the table, just click on the checkbox next to its name. As you do this, you will notice that the row will disappear from the table. This doesn't mean that the information is no longer available, it was just hidden from the table.
Add Row
To add a row back, simply click on the checkbox square, right next to its name. The row will be added immediately and the view will adjust all the information.
Rearrange Rows
You can also rearrange the rows in a way that best fits your needs. To do so, simply drag and drop the row to the desired spot. This is a great way to quickly organize your information within the Table.
Note: Any changes you make to the configuration will only be visible under your own profile. They will not impact your team members. To keep your current configuration or share it with your team, save it as a View, and don't forget to check the Share with team box.
To learn more about Saved Views, please visit the following tutorial:
Saved Views
All your existing Saved Views can be used for reporting purposes. With them, you can create powerful dashboards. To learn more about Dashboards, please visit the following tutorial:
Dashboards