MDX Query for 'Collapsing' Set
I have a need for a unique query and wanted to see if anyone had any ideas.
I wish to show a chart of products by annual sales. The list of products can be quite long so I would use topcount or toppercent or topsum to limit the list. But then I would like to show the remainder of the products as a member 'Other' which doesn't exist in the cube. So, in effect the top 15 products would be shown in detail in the graph but then the other 250 products would be collapsed and aggregated into an 'Other' member for the set.
I posted this in MDX and not Reporting Services since it is more a question related to member manipulation and not how to construct the graph.