I am working on a series of reports for a sales dashboard. All of the reporting services charts I am building display a top N in sales. What I would like to do is display the top N and their totals, but then group anything outside the top N and display as "other" and sum the total sales for that group. I have the top N part figured out, but I am not quite sure how to group anyone outside the top N.
These reports are built off of a SSAS cube, and I am not sure there is straight forward way to do this. My guess is I will have to write something in MDX which I am not very familiar with.
Any thoughts or suggestions would be greatly appreciated.