I. Overview
1) Sort data after expamsion: After expansion, data can be sorted according to the data in one column.
2) Prerequisite: Insert Formulas, Left Parent Cell and Upper Parent Cell.
II. Steps
1. Create a new dataset [ds1]
1) Create a new DB query dataset.
2) Input the SQL statement:
SELECT * FROM ProductLIMIT 10
2. Drag data columns into cells
1) Drag the data column [ProductID] into B2, [Product_name] into C2 and [Unit_price] into D2.
2) B2~D2: Set as center alignment and add borders.
3) Maintain the default expansion attributes of B2~D2
a) Expand Direction: Vertically
b) Left Parent Cell: Default
Note
Here, B2 is the parent cell of C2 and C2 is the parent cell of D2, indicating that B2 is the highest-level parent cell of the data in the second row.
Expanded Sort should be set in the highest-level parent cell.
3. Set the Expanded Sort attributes of B2
Expanded Sort: Null
4. Preview the effect
Data columns expand vertically. Data is displayed in the same order as stored in the table.
5. Expanded sort of B2: Ascending
1) Click the [Ascending] button. Click the [Formula] button.
2) Input D2 in the formula editor. Click OK.
6. Preview the effect
All data (in B2 and its sub-cells at all levels) are arranged in an ascending order by unit price.
7. Expanded sort of B2: Descending
1) Click the [Descending] button.
2) Maintain the text fields below unchanged.
8. Preview the effect.
All data (data in B2 and its sub-cells at all levels) is arranged in a descending order of unit price.
