SSAS group anything outside top N in SSRS report.

  • Group,

    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!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply