Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi:
I have a list of purchases per client and every transaction comes with different products. I need to count as one every transaction per client independently of the quantity. Needless to say, if a customer purchases 2 times, the answer should be 2
Thanks
post sample data please so can help.
The count should be "Destinatario" and "Document". E.G; The first client named "ZAIDA" has 3 different documents, so the answer should be 3.
Try,
Aggr(Count(Documents),Destinatario)
This example is even better, theres 1 customer and 1 document, but 8 different products, and the answer should be 1
didn't worked
maybe try:
Aggr(Count(Documents),Cliente)
Still 8
Aggr(Count(Distinct Documents),Cliente)
Doesn't work