Why sorting organizes visual display in Tableau - Formula Trace Breakdown

Sample Data

Sales data for different fruits showing product names and their sales numbers.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	150
A3	Bananas
B3	120
A4	Cherries
B4	180
A5	Dates
B5	90

Formula Trace

SORT(Product by Sales DESC)

Step 1: List products with sales: [(Apples,150), (Bananas,120), (Cherries,180), (Dates,90)]

Step 2: Compare sales values to order descending

Step 3: Rearrange products according to sorted sales

Cell Reference Map

    A        B
1 Product   Sales
2 Apples    150
3 Bananas   120
4 Cherries  180
5 Dates      90

Arrows: Sales values guide sorting order of Products

The sorting uses the Sales column (B2:B5) to reorder the Product names in column A.

Result

    A        B
1 Product   Sales
2 Cherries  180
3 Apples    150
4 Bananas   120
5 Dates      90

After sorting by Sales descending, the products are displayed from highest to lowest sales, making it easier to see top performers.

Sheet Trace Quiz - 3 Questions

What does sorting by Sales DESC do to the product list?

A Shows products from highest to lowest sales

B Shows products alphabetically

C Shows products from lowest to highest sales

D Does not change the order

Key Result

Sorting arranges data rows based on values in a chosen column to organize visual display.