"Carlos Krauss" <Carlos Krauss@discussions.microsoft.com> wrote in message
news:8249A296-6430-4D0D-A565-F679195695FB@microsoft.com...
>I am trying to get the Top N sales for the customers for a datawarehouse
> using the following MDX:
>
> ="SELECT {[Measures].[Net Sales],[Measures].[Qty Lb]} ON COLUMNS,
> TopCount(ORDER({[CustomerSalesPerson].[Name].Members},[2004], DESC),"&
> Parameters!TopCustomer.Value &") ON ROWS,
> {[TimeByMonth].[2004].[1]:[TimeByMonth].[2004].[12]} ON PAGES FROM
> [CustomerTopSales]"
>
> having a parameter to determinate the Top N.
>
> This works fine when my dimension (CustomerSalesPerson) has one level in
> the
> report, but when i want to show two levels of my dimension, it counts Top
> N
> considering both levels, like the following will be Top 5 when showing
> only 2
> customers:
>
> Customer 1
> Sales Person 1
> Sales Person 2
> Customer 2
> Sales Peron 3
>
> How can i made a Top N using the first level of the dimension?
>
> Any help
>
> Thanks
>