I am trying to find an average balance for a group with
the following data sample:

Group_1 A 10
B 10

Group_2 C 15
D 25

Group_1 the avg bal would be 10 and group_2 the avg bal
would be 20.

Currently, everything is being summed. The following
function I used for some reason sums my balances instead
of returning the correct avg's.

avg([group].[group].allmembers)

where group is my parent dimension, [All group] is my
parent member, and allmembers is my SET. Lunch is on me
for anyone who can solve my problem. Thanks

Lam