Generate Dimensional Function

[cognos05]

Hi,

I am trying to use the Generate dimensional function to achieve the below ,

How to get the top 5 reps and the top 5 customers under each rep.

The rep and customer being from same dimension but at different levels with rep being at top and customers next to it.

Will that be something like below ?

Generate(topcount(5,Reps),topcount(5,Customers))

Thanks,
Nithya

[cognos05]

Hi,

I used the below expression in my data item.

Generate(topcount([Sales].[Customer].[Customer].[Dist-Rep],5,tuple([Current FYTD],[Sales])),(TopCount([Sales].[Customer].[Customer].[Customer],5,tuple([Current FYTD],[Sales]))))

And this gives me only the 5 Customers ,

I m expecting something like

A  ABC
    Ac1
    AC2
    Ac3
    Ac4
    Ac5

B  D12
    E44
    K12
   C34
   F56

Like this for 5 reps and the 5 accounts under it.

But what I get is only five Accounts displayed.
    Ac1
    AC2
    Ac3
    Ac4
    Ac5

Please advise.

Thanks,
Nithya