Hi Community,
I've got the following issue.
I have got a table with one dimension (names) and several expressions (calculation based on uploaded data).
Now I want to use one of the items in the dimension list (flexible) as a reference which results in a calculation of differences in relation to this selected reference.
Example to explain it better:
Start table
| Name | Value | Delta to reference |
|---|
| A | 1 | - |
| B | 2 | - |
| C | 3 | - |
| D | 4 | - |
To select a reference name, a drop down box (containing A-B-C-D) should be shown.
When I select C in this box, this would result in the following table
| Name | Value | Delta to reference |
|---|
| A | 1 | -2 |
| B | 2 | -1 |
| C | 3 | 0 |
| D | 4 | 1 |
How can I create this drop down box. This list is flexible and depending on the selection in the Dimension of the table.
Thanks in advance for you quick respons.
Kind regards
