Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please i want to ask how to evaluate expression in a table dependent on a dimension (not the dimension of the table)
i mean if i have 2 dimensions x,y
and i have 2 expressions exp1,exp2
exp1 dependent on x
exp2 dependent on y
i want to make a straight table contain these two expressions and one dimension of them
how to make this
note, the values in x and y are the same but they can't be a relation between them.
Thanks in advance,
Mona.
Hi.
You can use total to discard dimensions in your expressions:
=sum(total<x> value)
=sum(total<y> value)