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
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