O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

$877,107.19

Top 2nd Reseller

$853,849.18

Top 3rd Reseller

$841,908.77

Top 4th Reseller

$816,755.58

Top 5th Reseller

$799,277.90

Other Resellers

     $76,261,698.37

All Resellers

     $80,450,596.98

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required