I try to create a Local Cube (Excel 2000) to work off line.
But, I can save only measures, not calculated members.
I've an average fields, that I obtain like calculated member.
Line, Turn, $, Kms
1,1,$ 5,100
1,1,$ 3
1,1,$12
--->$20/100
2,4,$10,150
2,4,$ 7
--->$17/150
Kms appears only one time for turn, I need sum($)/sum(kms).
This I obtain with a calculated member why this is an average. How can i obtain an average measure?
But, I can save only measures, not calculated members.
I've an average fields, that I obtain like calculated member.
Line, Turn, $, Kms
1,1,$ 5,100
1,1,$ 3
1,1,$12
--->$20/100
2,4,$10,150
2,4,$ 7
--->$17/150
Kms appears only one time for turn, I need sum($)/sum(kms).
This I obtain with a calculated member why this is an average. How can i obtain an average measure?