This sample report demonstrates the basic use of the BOTTOM command. The report is based on the Sample Basic database.
Measures Actual Budget Jan Dec Jan Dec ======== ======== ======== ======== East 200 158 233 280 340 300 184 277 240 210 Diet 181 213 200 240 West 100 378 223 830 530 300 755 971 830 950 400 454 434 470 370 South 200 480 496 520 390 Diet 355 404 490 430 300 188 213 270 240 Central 300 790 824 930 810 100 724 792 900 890 400 691 785 660 650 Market 200 2,141 2,302 2,710 2,810 300 1,917 2,285 2,270 2,210 400 1,611 1,720 1,730 1,600
Use the following script to create Sample 16-A:
<Sym <Column (Scenario, Year) Actual Budget Jan Dec <Row (Market, Product) <ICHILDREN Market <ICHILDREN Product <Bottom (3, @DataColumn(3)) !
The BOTTOM command specifies that only the three lowest data values are returned for each row grouping, based on the target data values specified in column three (Budget, Jan). Notice that no row dimension is selected here, so the report output defaults to the innermost row.
This report script, BOTTOM.REP, is available in the \ARBORPATH\App\Sample\Basic directory, and is displayed in Enterprise View in Administration Services.