Pivot table option

You can filter the values you want to display in your Pivot Table.

To do this, you have two options : apply a filter on the rows or on the columns or both.

Example

Here we have a Pivot Table with the invoice numbers in the rows, the invoice dates in the columns and the invoiced companies in the values.

I have previously filtered the columns of the DCT so that it only shows me the dates where I have an invoice.

Process

The parameters are located in the red box on the following image :

The left button is for row filters.

The right button is for column filters.

The column setting for the example is as follows :

We can see that we can uncheck the values we are not interested in or define a range of dates so that all the days with or without values are displayed :

Here is the rendering :

You can apply the same logic to the line settings options.

Of course, TimeTonic offers you the possibility to enter data directly from the Pivot table either by creating a new record via the button or by entering data directly into the Pivot table (ideal for entering timesheets for example!)