Finally, building a table cell-by-cell using the AsTable function is possible. It allows the creation of one row Table by manually defining id, label, and value.
The Union function can be used to build bigger Tables out of manually created rows, which look like this:
One of the most useful scenarios for this function might be to extend our TabReference results with an additional row with a completely custom calculation. We added a “Target value” row with some predefined figure in the example below.
If we sort the data, we can immediately identify the items below and above the target.
