MDX - Top count with aggregate
A few times now I have had a request to build a reporting services report where I show the TOP N customers followed by the subtotal and then a total of ALL OTHERS. This query could be broken out into three seperate MDX queries, but I want to use only one tablix in SSRS. Since you cannot point mulitple data sets at a single tablix, I came up a query that would give you a single data set in the correct order.
Read more...Tags: mdx