top n products by top n customers

[cognos12345]

Hi,

I need to create a cross-tab report (on DMR model), which will display revenue for top 5 customers (1st level) and top 5 products (2nd level) per each top customer.
I have problems defining data item for 2nd level (t.i. top 5 products).

If both levels would be from the same dimension, like top 5 products (2nd level) by top 5 product groups (1st level), you could simply use topCount function for 2nd level (t.i. products) > topCount ([Product], 5, [Revenue]).
But I have an issue that 2nd level category (t.i. product) is from different dimension and I don't know how to define data item to display top 5 products for each of previously defined top 5 customers.

Thank you for your help.

BR

[wyconian]

Hi

Take a look at this link from Norkos

http://www.cognoise.com/community/index.php/topic,20579.0.html