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!)
Comments
0 comments
Please sign in to leave a comment.