Sum distinct by customer

[maxime66]

Hi Qlikers.

I would like to get in the total line of the graphic attached 5 products (and not 7)

I tried Aggr stuff but it removes some lines ( i need to keep all the 4 rows displayed)

i also tried "sum( distinct [Nb product] ) " but  it make distinct on customer 23 and 50.

any ideas ?

thanx

[sunny_talwar · Accepted solution]

May be this

=If(Dimensionality() = 0, Sum(Aggr(Sum(DISTINCT [nb product]), customer)), Sum([nb product]))

[maxime66]

whaoo , thanks Sunny.

What is Dimensionality ? works very fine !!

[sunny_talwar]

Look here

How to use - Dimensionality()