Sample 5: Reporting on Different Combinations of Data
Each page represents a different combination of Product, Market, and Budget data. The total number of pages is determined by the number of Market and Product members. This section shows a representative part of the output.
Some data values have four decimal places. The number of decimal places, by default, is output to the true number of decimal values of the data cell. Sample 6: Formatting Different Combinations of Data uses the DECIMAL format command to define a specific number of places.
The member selection commands select three Product members and fourteen Market members, producing a 42-page report. The number of report pages is determined by multiplying the number of members selected from each page dimension.
Budget Audio New_York
Qtr1 Qtr2 Qtr3 Qtr4 Year
======== ======== ======== ======== ========
Sales 6,400 6,400 6,700 8,350 27,850
Cost_of_Goods_Sold 3,012 3,012 3,146 3,973 13,143
Margin 3,388 3,388 3,554 4,377 14,707
Marketing 525 515 475 555 2,070
Payroll 1,950 1,950 1,950 1,950 7,800
Miscellaneous 0 0 0 0 0
Total_Expenses 2,475 2,465 2,425 2,505 9,870
Profit 913 923 1,129 1,872 4,837
Profit_% 14 14 17 22 17
Margin_% 53 53 53 52 53
Budget Audio Boston
Qtr1 Qtr2 Qtr3 Qtr4 Year
======== ======== ======== ======== ========
Sales 6,050 5,750 5,900 7,350 25,050
Cost_of_Goods_Sold 2,829 2,695 2,762 3,413 11,699
Margin 3,221 3,055 3,138 3,937 13,351
Marketing 410 400 400 520 1,730
Payroll 1,590 1,590 1,590 1,590 6,360
Miscellaneous 0 0 0 0 0
Total_Expenses 2,000 1,990 1,990 2,110 8,090
Profit 1,221 1,065 1,148 1,827 5,261
Profit_% 20 19 19 25 21
Margin_% 53 53 53 54 53
Budget Product Market
Qtr1 Qtr2 Qtr3 Qtr4 Year
======== ======== ======== ======== ========
Sales 141,490 138,410 145,080 186,650 611,630
Cost_of_Goods_Sold 55,860 54,579 57,379 73,276 241,093
Margin 85,630 83,831 87,702 113,374 370,537
Marketing 10,555 10,680 10,780 13,915 45,930
Payroll 43,234 43,248 43,248 43,248 172,978
Miscellaneous 0 0 0 0 0
Total_Expenses 53,789 53,928 54,028 57,163 218,908
Profit 31,841 29,903 33,674 56,211 151,629
Profit_% 23 22 23 30 25
Margin_% 61 61 60 61 61
Use the following script to create Sample 5:
<PAGE (Scenario, Product, Market)
Budget
<ICHILDREN Product
<IDESCENDANTS Market
{ PAGEONDIMENSION Product } // New page at each new Product
{ PAGEONDIMENSION Market } // New page at each new Market
<COLUMN (Year)
<ICHILDREN Year
<ROW(Accounts)
<DESCENDANTS Accounts
!
This report script, COMBO1.REP
, is available in the \
ARBORPATH
\App\Demo\Basic
directory.