Hi

I'm working with our Marketing department, they want to group our customers
based on revenue, and produce analysis on the groupings, for example :-


GROUPING % OF TOTAL REVENUE REVENUE
AVERAGE GP%
TOP 10 Customers 10%
1 25
TOP 25 Customers 25%
3 15
TOP 50 Customers 50%
5 10
TOP 100 Customers 75%
7 14
ALL Customers 100%
10 16

I'm pretty new with Analysis services and MDX so I'm not quite sure where to
start with this request, can anybody give me any hints?

Probably for now (I'm guessing it would be easiest) the grouping would be
based on the revenue generated this year, but ideally it would be nice for
the grouping to be calculated based on the time period we are looking at.

I hope my questions makes sense, an example of an existing cube I have is

Dim - CUSTOMER
Dim - DATE (YEAR, QUARTER, MONTH)
Measure - REVENUE

Thanks

Here's a calculated member that aggregates the top 10 customers:

Aggregate(TopCount(Customer.Customer.Members, 10, Measures.Revenue),
Measures.Revenue)

Calculations are built inside the cube editor.

public @ the domain below
www.tomchester.net

"Paul" <pe (AT) nospam (DOT) com> wrote