When rendering a cross table, the report generator needs to know how the summary cell values are aggregated. The sum function is set using the Summary cell's Summary property. Each summary cell can have its own function. Cross table works with the following features:
| function | explanation |
| none | do not summarize cell values |
| sum | Returns the sum of the values contained in the cell |
| average | Returns the average of the values contained in the cell |
| minimum | Returns the minimum value contained in the cell |
| Max | Returns the maximum of the values contained in the cell |
| count | Returns the number of values contained in the cell |
| Count Distinct | Returns the number of distinct values contained in the cell |
| image | The cross table shows the first value as an image |
In addition to the Summary property, there are other properties that affect the summary. This is the SummaryValues property. This property identifies and handles 0 and null values when calculating the sum.
English 
Japanese