Hi -

I need help. We have a a cube that has just two measures...termination
count and head count. For every employee, for every day we have a
tuple. If the employee continued employment their term count is zero
and their head count for the day is 1. If they were termed that day,
both measures are 1.

I am using this calculation:

AVG([Date].[Day].AllMembers, [Measures].[Head Count])

But I don't want "AllMembers" what I want are all currently selected
members...so that if the user chooses a week long period - I only want
it to average the week they have chosen. How do I do that?

thanks in advance.