Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here is one way.