Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Unfortunately just gives a 0 rather than a blank for the other rows
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) )
Unfortunately just gives a 0 rather than a blank for the other rows