I have a Customer Dimension, that looks as follows:

All Customers
Area A
Metro
Customer A
Customer B
Customer C
etc.
Rural
Customer D
Customer E
Customer F
etc.
Area B
Metro
Customer G
Customer H
Customer I
etc.
Rural
Customer J
Customer K
Customer L
etc.

I need to create a calculated member to reflect the average of each
measure for the top 5 customers per region (metro/rural). E.g. Find
the top 5 customers within Area A, Metro. Once they are identified,
sum the measure selected and divide by 5.

maybe a formula like this can help you (not tested):
Avg(TopCount(Customers.Customer.members, 5, Measures.Sales), Sales)

Dividing by 5 is not an option, because if you have only 3 customers you'll
get a wrong result.


"zee" <zelda.calitz (AT) bmw (DOT) com.au> a écrit dans le message de news:
c726d6d2.0409121853.233e0511 (AT) po...OT) google.com...

How do you specify that TopCount must be applied to the children of
the relevant hierarchy? I suspect what is happening it that it
calculates the average for the top customers across all the customers.

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

this formula list all customers under the current selected member in the
customers dimension:
descendants(Customers.currentmember, Customer)

So, if you select the area "Area A", you'll have only the customers of the
Area A
if you selevct "Area A" --> Metro; you'll have only the customers under this
member.

so the formula become:
Avg(TopCount(descendants(Customers.currentmember, Customer), 5,
Measures.Sales), Sales)


"zee" <zelda.calitz (AT) bmw (DOT) com.au> a écrit dans le message de news:
c726d6d2.0409131516.2aebd5a1 (AT) po...OT) google.com...

Thanks, I think I have it now.
Avg(TopCount(Descendants([Customers].CurrentMember,
[Customers].[Description]), 5, [Measures].[Quantity Sold]),
[Measures].[Quantity Sold])

zelda.calitz (AT) bmw (DOT) com.au (zee) wrote in message news:<c726d6d2.0409121853.233e0511 (AT) posting (DOT) google.com>...