CONTENTS
Chapter 1 Installation & Trial
- 1.1 Download & install
- 1.2 Create row-wise reports through wizard
- 1.3 Expansion & expression
- 1.4 Report zone
Chapter 2 Appearance & format
- 2.1 Border, font and color
- 2.2 Display format and display value
- 2.3 Conditional format
- 2.4 Card-style report
- 2.5 Picture
- 2.6 Exercises
Chapter 3 Grouped report
- 3.1 Create grouped reports through wizard
- 3.2 Common grouped reports
- 3.3 Structure of a grouped report and master cell
- 3.4 Computations on a grouped report
- 2.5 Picture
- 3.5 Exercise
Chapter 4 Crosstab report
- 4.1 Create crosstab reports through wizard
- 4.2 Common crosstab reports
- 4.3 Structure of a crosstab report & master cell
- 4.4 Computations on a crosstab report
- 4.5 Exercise
Chapter 5 Multizone association
- 5.1 From crosstab to zones
- 5.2 Coexistence of expanding and static areas
- 5.3 Equality of row and column
- 5.4 Make a master-sub table through multizone association
- 5.5 Exercise
Chapter 6 Inter-cell computations
- 6.1 Calculate proportion, running total & simple YOY growth
- 6.2 Calculate ratio & complex ratio
- 6.3 Calculate conditional aggregate, ranking & complex YOY growth
- 6.4 Get ordinal number in one group/across groups
- 6.5 Exercise
Chapter 7 Irregular sorting & grouping
- 7.1 Incomplete grouping
- 7.2 Sorting & grouping by the specified order
- 7.3 Grouping by segment
- 7.4 Grouping by specified conditions
- 7.5 Exercise
Chapter 8 Parameters & scripts
- 8.1 The concept & uses of parameters
- 8.2 Dynamic parameters
- 8.3 Reports with dynamic columns
- 8.4 Variables & scripts
- 8.5 Exercise