Columns is a date and the row has a hierarchy of All Orders and Order.
Measure is a Lead Time. If drill down to an order, get the lead time for the
order. But, drill up to "All Orders" for the date, I get the sum of all
orders.

For Example

Order A 10
Order B 20
Order C 15

I get All Orders - 45
What I am trying to achieve is All Orders - 15

How is that done. Set the DataAggregation to "AverageofChildren". But,
doesn't seem to work. Any help would be greatly appreciated.

"AverageofChildren" will only average over the time dimension, so for
your case you could add a "Count" aggregation measure on the same
measure group like [OrderCount]. Then, if you use "Sum" aggregation for
[Lead Time], [AvgLeadTime] can be computed as: [Lead Time] /
[OrderCount].


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***