The following sample has two regular columns defined in asymmetric mode. For an explanation, including an example, of the use of asymmetric columns, see Sample 13: Creating Asymmetric Columns.
East Budget Actual Actual Jan Jan % Sales ======== ======== ======== 1,200 Television Payroll 1,236 25% 440 Marketing 365 9% 1,240 Profit 1,295 26% 4,800 Sales 5,244 100% 1,030 VCR Payroll 1,044 25% 150 Marketing 156 4% 1,466 Profit 1,417 35% 4,200 Sales 4,311 100% 1,195 Camera Payroll 1,167 42% 300 Marketing 288 11% 528 Profit 400 19% 2,850 Sales 2,656 100% 3,425 Visual Payroll 3,447 29% 890 Marketing 809 8% 3,234 Profit 3,112 27% 11,850 Sales 12,211 100%
Use the following script to create Sample 14-B:
<PAGE(Market) East <COLUMN(Scenario, Year) Budget Actual Jan Jan { ORDER 2,0,1,3,4 WIDTH 12 0 1 NOINDENTGEN AFTER "%" 4 SKIPONDIMENSION Product LMARGIN 10 } <ROW(Product, Accounts) { CALCULATE ROW "Sales" OFF } { CALCULATE COLUMN "Actual~% Sales" = 2 % "Sales" 2 } <ICHILDREN Visual { SAVEROW } Sales Payroll Marketing Profit <DUPLICATE Sales !
This report script, COLCALC3.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.