The Source Table:
You can change the filtration criteria, the pivot table and chart parameters on the fly.
The changes will be automatically applied to the data from the Office Excel macro.
In this use case filtered data, the pivot table and chart will be automatically updated when the ConfiForms Form is filled in.
Table Transformer & ConfiForms TableView
1. Add the Table Transformer macro to ConfiForms TableView.
You can place one or multiple tables within the macro body to merge, look up them or to perform custom calculations.
This SQL query allows you to create a new column with data outputted by condition.
You can use the ConfiForms TableView macro with each of our macros separately or combine them according to your needs.