Averages

[katams]

I am trying to display averages and totals. I think I have the totals; it's the averages I'm having trouble with.

For example
Year 2000 Year 2001 Averages

AllStores 100 $100,000 10 $1,000 55
Store A 25 $10,000 3 $500 14
Store B 25 $10,000 2 $250 13
Store C 50 $80,000 5 $250 27

I also need them for the dollar amounts, too.

Any ideas?

 

[datawarehousing]

if u want to add dollor sign to that average amount, change to text format and concatinate the dollor sign .

 

[Kelee]

This will give you averages over time:

([Time].currentmember,[Measures].[Units Shipped])/count (descendants([Time].currentmember, [Month]))

or, this pretty much does the same thing:

[Measures].[Units Ordered]/count(descendants([Time].currentmember, [Month]))

Good luck