Displaying a few important members, with the others as a single row, and the total at the end

There are times when isolating the best or worst members is not enough. In addition to the few important members, business users often want to see the total of all the other not-so-important members, as well as a single row representing the total of all the members.

An example of this type of reporting requirement is shown in the following table:

Reseller Sales Amount

Top 1st Reseller


Top 2nd Reseller


Top 3rd Reseller


Top 4th Reseller


Top 5th Reseller


Other Resellers


All Resellers


In the first recipe in this chapter, Isolating ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.