Hi,
I want to make table with calculated average as follow:
1 2 3 4 5 avg
------------------ ----
a 2 0 3 1 2 3.125(=1*2+2*0+3*3+4*1+5*2 /2+3+1+2)
The measure is num of company, i.e at type a and factor 2 the num is 2.
the calculated avg I need to calculate by myself (calculated member as measure) but i don't know how.
Can this be done and how?
thanks.
I want to make table with calculated average as follow:
1 2 3 4 5 avg
------------------ ----
a 2 0 3 1 2 3.125(=1*2+2*0+3*3+4*1+5*2 /2+3+1+2)
The measure is num of company, i.e at type a and factor 2 the num is 2.
the calculated avg I need to calculate by myself (calculated member as measure) but i don't know how.
Can this be done and how?
thanks.