Calculating field summaries in CrossTab reports
You can calculate the field summaries in a CrossTab report to give you an overall look at the data. You can choose from many field summary options, including calculating the sum, average, and standard deviation. Only fields in the data position of CrossTab reports can be summarized, because they are the fields that have numeric values.
To calculate a field summary in a CrossTab report |  |
|
1.
|
|
Click a data field.
|
|
2.
|
|
Click Tools
 Data tools CrossTab Field options. |
|
3.
|
|
Enable any of the following check boxes in the Summary list:
|
|
•
|
Sum — calculates the sum of items for numeric field items
|
|
•
|
Count — calculates the number of occurrences for label field items
|
|
•
|
Average — calculates the average
|
|
•
|
Max — displays the maximum value
|
|
•
|
Min — displays the minimum value
|
|
•
|
StdDevp — calculates the population standard deviation
|
|
•
|
StdDevs — calculates the sample standard deviation
|
|
•
|
Varp — calculates the population variance
|
|
•
|
Vars — calculates the sample variance
|
|
•
|
CountNonBlank — counts non-blank cells for a field
|
|
•
|
|
You cannot drag field summaries because they are superficially generated on the report.
|
|
•
|
|
You can display an enormous amount of information about your data if you enable all of the summary options; including only those options which are most relevant makes the report easier to read.
|