Help me please, how to count distinct product for each customer in expressions (red figures)?
Count (Distinct <Customer> Product)
with AGGR result is:
>>Count (Distinct <Customer> Product)
here is QV writes about error.
I want to show only customers&products with products count = variable
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.
thank you! it's works!
Retrieving data ...