...
ConfiForms Form Definition | ||||
---|---|---|---|---|
| ||||
|
So, we have a form with 4 fields
...
- type - dropdown field
- description - text are field to store invoice item details
- price - numeric field to store numeric data for item price
- count - numeric field to store number of items per that price
...
ALL stored data
ConfiForms TableView | ||
---|---|---|
| ||
|
To get Totals per type
We have 2 fields in TableView Merger, type and Total which is described as expression
...
ConfiForms TableView Merger |
---|
|
Record ID is used as a grouping key, together with a type and therefore rows are showed separately
...
ConfiForms TableView Merger |
---|
Same, as above, but description field used as a grouping key, together with a type and therefore rows are showed separately.
...
ConfiForms TableView Merger |
---|
Chart showing invoice items grouped by TYPE and with their totals (Chart macro uses the same table as you can see in 1st example, where we group by type field and calculate totals per row)
...