InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:31:06 GMT20http://www.sqlservercentral.com/Forums/Topic1403606-1063-1.aspxGroup,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.Thanks!Mon, 07 Jan 2013 07:38:45 GMTjtousignant