Skip to main content

Recreatex documentation

Set Up a Filter

  • Post-filter

You can place the desired filter fields on your pivot table in the row, column or filter area and by clicking on the filter icon afterwards to set up the filter.

rptng_clip0063.png

You will then be able to select or deselect all rows, columns or other filter conditions you want to see or not.

rptng_clip0064.png

Note

When using the post-filter, all the data of the data source is fetched and loaded but is filtered before visualisation.

The post filter is easier to use when, for example, changing the visualisation on the fly and the data does not need to be reloaded.

  • Pre-filter

You can also choose to use the Filter window wherein you can define different filter conditions.

rptng_clip0066.png

Note

When using the pre-filter, only the data that is compliant with the filter conditions will be shown in the pivot table.

rptng_clip0067.png

Add a new condition to this group.

rptng_clip0068.png

Delete this condition.

rptng_clip0069.png

If you click this option you can determine the relation between the conditions. Here you can also add a new group or condition, as well as delete the entire filter.

rptng_clip0070.png

This is the field on which you want to apply the filter. If you click on this field, all fields that are available for the filter will appear.

rptng_clip0071.png

Here you can determine the condition of the field.

rptng_clip0072.png

Here you can fill in the value that has to be met by the chosen field.

Note

After adding the filter conditions, click Refresh to refresh the pivot with filtered data.

After setting up the filter, you still have to save it by clicking on Save.

In this section: