CONTENTS
Chapter 1 Functional sections
- 1.1 Data files
- 1.2 Dataset panel
- 1.3 History command
- 1.4 Edit command
Chapter 2 Interface computations
- 2.1 Add computed columns
- 2.2 Filter data
- 2.3 Sort data
- 2.4 Group data
- 2.5 Concatenate detailed data
- 2.6 Select fields
- 2.7 Transpose rows/columns to columns/rows
- 2.8 Data association
- 2.9 Set operations
Chapter 3 Comprehensive scenarios
- 3.1 Aggregation on a computed column in a grouped table
- 3.2 Intragroup sorting on a grouped table
- 3.3 Intragroup filtering on a grouped table
- 3.4 Retain the first row of each group
- 3.5 Grouping & aggregation after filtering
- 3.6 Compute link relative in a multilayer-structure table
- 3.7 Comparison between multiple tables
Chapter 4 Comprehensive use cases
- 4.1 Get stock transaction records meeting the specified condition
- 4.2 Compute LRR and YOY based on car sales table
- 4.3 Associate worksheets and compute salaries
- 4.4 Find salespeople who rank top5 every month
Chapter 5 Editing result set
- 5.1 Data rows
- 5.2 Data columns
- 5.3 Cell value expression
- 5.4 Save and export