Examples of ascending and descending column values
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) |