expression in a table

Wed, 26 Sep 2012 11:31:57 GMT

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.

Re: expression in a table

whiteline — Wed, 26 Sep 2012 15:38:05 GMT

Hi.

You can use total to discard dimensions in your expressions:

=sum(total<x> value)
=sum(total<y> value)