TimeTonic allows you to create pivot tables to facilitate the management of your business. 

Create a pivot table 

1. Click on the table options

2. Then click on Create a Pivot table

3. Enter a title for your Pivot table and a description if necessary. 

4. Configure your Pivot table by clicking on the following button. 

A window will appear allowing you to configure your Pivot table 

Rows

Select the TimeTonic field to be displayed in rows.

Columns

Select the TimeTonic field to be displayed in columns.

Values

Select the TimeTonic field to be displayed as data.

Colors

Select the TimeTonic field to apply a color (must be of type Selection)

Calculation mode

Select the calculation mode impacting your values. 

Note that the available modes will vary depending on the type of column in value.

For all column types : 

• Count : counts the number of records
• Count % : counts the number of records as a percentage

For all column types number : 

• Sum : sum your values
• Sum % : sum your values in percentage
• Count : count the number of records
• Count % : count the number of records in percentage
• Average : average your values

For the editable column types (except for formulas)

• Editable : allows you to edit the value directly from your Pivot Table

Filter with 

You can select a link type field to display a filter tool allowing you to display only the data concerned by this link filter.