User`s guide

Summarizing grouped data...................................................................................................166
8.3
To summarize grouped data.................................................................................................166
8.3.1
Ordering groups by summarized values................................................................................167
8.3.2
Selecting top or bottom N groups or percentages................................................................168
8.3.3
Selecting top or bottom groups or percentages conditionally...............................................170
8.3.4
Subtotaling...........................................................................................................................171
8.4
Subtotaling data...................................................................................................................171
8.4.1
Extending prices and subtotaling the extensions...................................................................172
8.4.2
Percentages.........................................................................................................................173
8.5
Calculating a percentage......................................................................................................174
8.5.1
Group headers.....................................................................................................................175
8.6
Creating group headers........................................................................................................175
8.6.1
Suppressing group headers.................................................................................................179
8.6.2
Drilling-down on group headers............................................................................................179
8.6.3
Running Totals....................................................................................................................181Chapter 9
Understanding running totals................................................................................................181
9.1
How running totals work.......................................................................................................181
9.1.1
Creating running totals.........................................................................................................182
9.2
Creating running totals in a list.............................................................................................182
9.2.1
Creating running totals for a group.......................................................................................184
9.2.2
Creating conditional running totals.......................................................................................185
9.2.3
Creating running totals in a one-to-many linking relationship.................................................187
9.2.4
Creating running totals using a formula.................................................................................188
9.3
To create running totals using a formula...............................................................................188
9.3.1
Multiple Section Reports.....................................................................................................191Chapter 10
About sections.....................................................................................................................191
10.1
Working with sections..........................................................................................................191
10.2
Inserting a section................................................................................................................192
10.2.1
Deleting a section................................................................................................................192
10.2.2
Moving a section..................................................................................................................193
10.2.3
Merging two related sections...............................................................................................193
10.2.4
Splitting and resizing sections..............................................................................................194
10.3
Splitting a section.................................................................................................................194
10.3.1
Resizing a section................................................................................................................195
10.3.2
Using multiple sections in reports ........................................................................................196
10.4
Keeping variable length objects from overwriting each other................................................196
10.4.1
Eliminating blank lines when fields are empty........................................................................197
10.4.2
Adding blank lines conditionally............................................................................................198
10.4.3
2012-03-147
Contents