Report Portal

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

 

2007-2015 VidasSoft Systems Inc.