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
Hi
Take a look at this link from Norkos
http://www.cognoise.com/community/index.php/topic,20579.0.html