Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to include Calculated members in Locals Cubes?

Status
Not open for further replies.

peterlog

IS-IT--Management
Dec 27, 2000
3
AR
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top