AGGR Count

[aliyoung92]

I've got a straight table where I want to do a count to get the total for one dimension:

Dim 1    Dim 2   Dim 3  Dim 4    Count    Required Column 

A             B            C            E             10            15

A             B            D            E             5               15

I want to get a total count for the table. I've tried:

 = AGGR(COUNT( DISTINCT Field),Dim1, Dim2, Dim4)  

This works for the first line in the table, but then I just get a blank for the second.

Does anyone know of a solution?

[Anonymous]

Try the following:

=SUM( AGGR(COUNT( DISTINCT Field),Dim1) )+SUM( AGGR(COUNT( DISTINCT Field),Dim2) )+SUM( AGGR(COUNT( DISTINCT Field),Dim3) )+SUM( AGGR(COUNT( DISTINCT Field),Dim4) )

[aliyoung92 · Accepted solution]

Unfortunately just gives a 0 rather than a blank for the other rows