
Contributor III
2021-05-06
04:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count Unique by dates
Hi everbody,
I need to count by the name field, but I have sales on different dates to the same Customer.
I attach the example.
Carlos has sales to different clients (M1, M2, M3) but to M1 he has three sales in the same month, for the count it should only be considered as one sale; and one to M2 and one to M3, total Carlos three sales.
Sandra has two sales to the same M4 customer, and overall Sandra must be one sale.
Total Maria a sale
491 Views
1 Reply

Specialist
2021-05-06
04:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think you are looking for:
count(Distinct [Customer])
472 Views
