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 ...
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.
