Hi, I am new to SQL Analysis Services. I created a simple cube in
SQLAS 2005 and added a calculated member: Avg Daily Sale = Sale / 30

To better illustrate, the data is aggregated below:
Location A 2007 Cost Avg Daily
Cost
01 $40,000 $
1,333.33
02 $50,000 $
1,666.67
03 $90,000 $ 3,000.00
04 $55,000 $ 1,833.33
Total: $235,000.00 $ 7,833.33

The result for the TOTAL Avg Daily Cost Rollup is not correct. It
should have been the average of all the avg daily costs for 2007
above: $ 1958.33

Question. How can I create a custom rollup to represent the correct
calculation ?

Any help will be greatly appreciated!