Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following building block example shows an ascending sort on the values in column D of the report for rows 160 through 490. It also shows how a descending sort on the absolute values in column G of the report for rows 610 through 940 is set up.
Examples of ascending and descending column values
Row Code |
Description |
Format Code |
Related Formulas/Rows/Units |
Normal Balance |
Column Restriction |
Link to Financial Dimensions |
|---|---|---|---|---|---|---|
100 |
Sorted by Monthly Variance in Ascending Order |
DES |
|
|
|
|
130 |
|
SORT |
160:490 |
|
D |
|
160 |
Sales |
|
|
C |
|
4100 |
190 |
Sales Returns |
|
|
|
|
4110 |
|
... |
|
|
|
|
|
490 |
Interest Income |
|
|
C |
|
7000 |
520 |
|
DES |
|
|
|
|
550 |
Sorted by YTD Absolute Variance in Descending Order |
DES |
|
|
|
|
580 |
|
ASORTDESC |
610:940 |
|
G |
|
610 |
Sales |
|
|
C |
|
4100 |
640 |
Sales Returns |
|
|
|
|
4110 |
|
... |
|
|
|
|
|
940 |
Interest Income |
|
|
C |
|
7000 |
The report resembles the following example.
|
Variance Analysis (Sorted by Variance) |
||||||
|
Beijing and Atlanta Regions |
||||||
|
For the Seven Months Ending July 31, 2013 |
||||||
|
|
July |
YTD |
|
|
|
|
|
|
Actual |
Budget |
Variance |
Actual |
Budget |
Variance |
|
Sorted by Monthly Variance in Ascending Order |
||||||
|
COGS |
873,872 |
236,144 |
(637,728) |
4,864,274 |
1,590,315 |
(3,273,959) |
|
Salaries and Wages |
97,624 |
65,573 |
(32,051) |
653,884 |
441,664 |
(212,220) |
|
Sales Discounts |
36,383 |
24,152 |
(12,231) |
241,562 |
162,670 |
(78,892) |
|
Sales Returns |
10,917 |
7,246 |
(3,671) |
62,809 |
48,803 |
(14,006) |
|
Rent Expense |
12,052 |
9,019 |
(3,033) |
80,444 |
60,748 |
(19,696) |
|
Office Expense |
5,023 |
3,291 |
(1,732) |
33,420 |
22,098 |
(11,322) |
|
Travel Expense |
7,656 |
7,641 |
(15) |
51,062 |
51,469 |
407 |
|
Sales |
1,240,119 |
410,389 |
829,730 |
7,139,288 |
2,764,549 |
4,374,739 |
|
Sorted by YTD Absolute Variance in Descending Order |
||||||
|
Sales |
1,240,119 |
410,389 |
829,730 |
7,139,288 |
2,764,549 |
4,374,739 |
|
Travel Expense |
7,656 |
7,641 |
(15) |
51,062 |
51,469 |
407 |
|
Office Expense |
5,023 |
3,291 |
(1,732) |
33,420 |
22,098 |
(11,322) |
|
Sales Returns |
10,917 |
7,246 |
(3,671) |
62,809 |
48,803 |
(14,006) |
|
Rent Expense |
12,052 |
9,019 |
(3,033) |
80,444 |
60,748 |
(19,696) |
|
Sales Discounts |
36,383 |
24,152 |
(12,231) |
241,562 |
162,670 |
(78,892) |
|
Salaries and Wages |
97,624 |
65,573 |
(32,051) |
653,884 |
441,664 |
(212,220) |
|
COGS |
873,872 |
236,144 |
(637,728) |
4,864,274 |
1,590,315 |
(3,273,959) |