Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with two dimensions, as i get the value of a specific cell?
eg.
Dimension 1
Dimension 2
Expression 1
Expression 2
Expression 3
Expression 4
If the dimensions 1 and 2 are horizontal, eg.
--------------- Dimension 1-1------------------ --------------- Dimension 1-2 ------------------
Dimension 2-A | Dimension 2-B | Dimension 2 A | Dimension 2-B | |
---|---|---|---|---|
Expression 1 | ||||
Expression 2 | ||||
Expression 3 | ||||
Expression 4 |
As i can do in <Dimension 1-1, Dimension 2-B>
Expression 3 = [Expression 1 <Dimension 1-1, Dimension 2-A>] / [Expression 3 <Dimension 1-1, Dimension 2-A>]
thanks.
For anyone having the same problem.
I tried to use macros, i did not know how.
Finally the expression of some cells, i stored in variables and so, instead of referring to cells, only use the variables.
eg.
var_expression1_A =sum(<expression>)
var_expression1_B =avg(<expression>)
expression 3 = if(dimension1=1 and dimension2='B', $(var_expression1_A)/$(var_expression1_B))