# 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

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)