The following sample was created using the function Print
® Mass print drilldown list.Report Definition
The report definition contains the following:
Print Settings
The following settings were made in the Print setup:
The entire report was printed. That means that the system "drilled down" through all the levels of the report for the printout.
The Printout
The initial list shows the individual sales organizations, summarized across all the customer groups and industries.
The sales organizations are:
The customer groups include:
The list begins with the first sales organization, Office North US, and the first customer group Industrial customers, broken down by the individual industries Chemical industry, High Tech, Manufacturing, and so on. The individual industries are followed by the total for the customer group Industrial customers, which is indicated with an asterisk.
This is followed by the second customer group Trading companies in the first sales organization, Office North US, again broken down by the individual industries. After the individual industries comes the total for the customer group Trading companies in the sales organization Office North US, which is likewise indicated with an asterisk.
Finally, the values in the sales organization Office North US that are not assigned to a customer group are displayed under Not assigned.
The sum of all of these rows is then displayed in the totals row for the sales organization Office North US, which is indicated with two asterisks. This completes the information for that sales organization.
The other sales organizations, Office South US, Office East US, Office West US, Office Canada and Not assigned, are then broken down in the same fashion according to customer groups. The customer groups are likewise broken down according to industries.
At the bottom of the printout, the grand total for all sales organizations is displayed in the row "Result" and indicated with three asterisks.
Sales office ** |
Customer group * | ||
Industry |
Inv. Qty |
Revenue | |
CHEM Chemical Industry |
12.000 |
143,320.00 | |
HITE High Tech |
8,416.000 |
27,393,240.00 | |
MBAU Manufacturing |
4,916.000 |
15,092,464.00 | |
MEDI Media Industry |
2.000 |
6,720.00 | |
TRAD Trade |
1,235.000 |
4,607,864.00 | |
# Not assigned |
4,742.000 |
69,700.00 | |
* 01 Industrial customers |
14,519.000 |
47,312,308.00 | |
CHEM Chemical industry |
4,742.000 |
14,585,486.00 | |
HITE High Tech |
6,069.000 |
19,271,264.00 | |
TRAD Trade |
7.000 |
53,830.00 | |
* 02 Trading companies |
10,818.000 |
33,910,580.00 | |
# Not assigned |
0.000 |
24.66 | |
* Not assigned |
0.000 |
24.66 | |
** 0001 Office North US |
25,409.000 |
81,222,912.66 | |
CHEM Chemical industry |
4.000 |
36,800.00 | |
ENER Energy research |
6,049.000 |
19,364,676.00 | |
MBAU Manufacturing |
1,326.000 |
4,917,492.00 | |
TRAD Trade |
4,843.000 |
14,998,692.00 | |
# Not assigned |
0.000 |
12,378.00 | |
* 01 Industrial customers |
12,222.000 |
39,330,038.00 | |
HITE High Tech |
6,105.000 |
18,021,071.50 | |
MBAU Manufacturing |
2,470.000 |
8,750,216.00 | |
TRAD Trade |
3,930.000 |
12,446,964.00 | |
* 02 Trading companies |
12,505.000 |
39,218,251.50 | |
** 0002 Office South US |
24,727.000 |
78,548,289.50 | |
MBAU Manufacturing |
80.000 |
813,077.06 | |
* 01 Industrial customers |
80.000 |
813,077.06 | |
MBAU Manufacturing |
24.000 |
204,230.79 | |
TRAD Trade |
102.000 |
1,008,938.49 | |
* 02 Trading companies |
126.000 |
1,213,169.28 | |
TRAD Trade |
61.000 |
308,758.70 | |
# Not assigned |
8.000 |
63,230.79 | |
* Not assigned |
69.000 |
371,989.49 | |
** 0003 Office East US |
275.000 |
2,398,235.83 | |
HITE High Tech |
25.000 |
76,937.46 | |
* 01 Industrial customers |
25.000 |
76,937.46 | |
TRAD Trade |
0.000 |
84,584.62 | |
* Not assigned |
0.000 |
84,584.62 | |
** 0004 Office West US |
25.000 |
161,522.08 | |
MBAU Manufacturing |
0.000 |
0.00 | |
* 01 Industrial customers |
0.000 |
0.00 | |
** 1010 Office Canada |
0.000 |
0.00 | |
ENER Energy research |
3.000 |
21,901.10- | |
# Not assigned |
0.000 |
36,378.00- | |
* 01 Industrial customers |
3.000 |
58,279.10- | |
HITE High Tech |
0.000 |
45,000.00- | |
TRAD Trade |
0.000 |
420.00- | |
* 02 Trading companies |
0.000 |
87,200.00- | |
CHEM Chemical industry |
11.000 |
134,339.73 | |
MBAU Manufacturing |
0.000 |
0.00 | |
TRAD Trade |
20.000 |
553,846.15 | |
# Not assigned |
144.000 |
312,770.00 | |
* Not assigned |
175.000 |
1,000,955.88 | |
** Not assigned |
178.000 |
855,476.78 | |
*** Result |
50,614.000 |
163,186,436.85 |