Consider the following report in Strategy Developer (formerly Desktop) which has crosstab nulls in the empty cells. Applying the Count subtotal to the grid returns a count of the existing metric values, not a count of the rows.
NOTE: Cross tab nulls may result when the attributes on the rows (Employee) and the attribute in the column (Call Center) are related in a hierarchy.
The Count subtotal by definition cannot include crosstab nulls. The Count function in Strategy does have a parameter to include or exclude nulls, but including nulls can only count rows that exist in the result set. The result set for this report contains five rows: three for San Diego and two for New Orleans. When the subtotal is calculated for the San Diego column, the Analytical Engine has only three rows to consider, so its value can never be greater than three.
If a custom subtotal is defined to count the attribute level of the rows, then the subtotal will yield a count of the rows displayed as a result of cross tabulation -- for this example report, 5. To create a such custom subtotal, perform the following steps. Note that it is not technically correct to say that this custom subtotal counts crosstab nulls along with the existing values. Rather, it counts a different entity that produces the desired subtotal value.
The report will now display Employee Count in the subtotals. All rows are counted, even those without metric values.
