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.
