Sample 14-B: Asymmetric Columns

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.