Hi,
I have a junk dimension,the dimension explained below store values for
each member as explained below
this is one of the type of Junk dimension

the dimension is explained as below

Parent1
A ==> Number
B ==> Number
C ==> Number
D ==> Percent(decimal)
Parent2
E ==> Number
F ==> Number
G ==> Number
H ==> Percent(decimal)

At parent 1 it should show only the sum of A,B,C
similarly At parent2 it should show only the sum of E,F,G

but the problem arises at higher level of time dimension

Suppose my lowest level in time dimension is month,it should work as
above

but if i go to Quarter level and Year level apart from summing the
counts, it should also average the percent(decimals)

can any one explain and suggest me proper solution for the same

Your solution is highly appreciated