Processing Values for Summary

 

The Cross-Tab has the SummaryValues property, which allows you to display the total number of values of the cross-table, considering or not considering to 0 and/or null values. The SummaryValues property can take three values, depending on the value of the property, the number of values will be displayed as a result. Values of the SummaryValues property and their description are described in the table below:

 

Function

Description

AllValues

All values, contained in a cell

SkipZerosAndNulls

Skip 0 null values, contained in a cell

SkipNulls

Skip null values, contained in a cell