How to count distinct product for each customer in expressions?

[#1]

Hello

Help me please, how to count distinct product for each customer in expressions (red figures)?

[MK_QSL]

Aggr(Count(DIstinct Product),Customer)

or

Count (Distinct <Customer> Product)

[#3]

with AGGR result is:

>>Count (Distinct <Customer> Product)

here is QV writes about error.

[#4]

I want to show only customers&products with products count = variable

[swuehl · Accepted solution]

Could you upload a small sample application?

Customer and Product are dimensions in a table chart right, but not the only two dimensions, there are some more, right?

I think something like

=COUNT(TOTAL<Customer> DISTINCT Product)

as expression should return what you want.

[#6]

thank you! it's works!