What would be the MDX query to view top 10 item sales per Company.
Currently, I have created a Named Set to view the top 10 items:
[Item].[Item Num Name].[Item Num Name].
This gives me top 10 items overall (from All the companies).
Actually, I need an MDX query which should be such that, if i filter the results by company it should show me top 10 items in that company.
If i remove the company filter , it should show me overall top 10 items. It should be dynamic.
Any ideas. Please help.
View Complete Post