Currently we have a dimension which has following levels

Level 1
member 1
member 2
member 3
Level 2
member 4
member 5
member 6

the dimension table structure is

PSSID Mgroup MDetail


Mgroup will have Level1 and Level2

Mdeatil will have the member1,member2 ....member 6


member 3 and member 6 have percent values(decimal) and and all other
are counts

the values for member1,member2 ....member 6 are stored in single
measure called KPI

KPI in the fact table has data format of decimal


the fact table structure for this cube is

PSSID,TimeID,KPI


So rollup at level1 and Level will sum the percent and counts.

Can you please explain how can i handle this aggregation at higher
levels with differing vlaues (percent & count)

Can this be achieved using custom rollup formula or any other method.

What changes i need to make in the dimension if required
Please help