Retaining Items Deleted from the Data source
If you create a new report, in PivotTable format, using Alchemex, off a standard container then when you export this report and import it into another database, by default it will retain the filter fields that were used in the original report. To see, use the filter fields that relate to the new database you need to change the Data Options of the PivotTable before exporting the report and importing it into your new database.
- Run your report
- Right click on PivotTable. Choose PivotTable Options
- Go to the Data Tab, then Select None from the Number of Items to retain per field. (The default is always set to Automatic)
4. Select OK and create and link your template
