bookalaka

Accounts Sold by Week

Discussion created by bookalaka on Feb 14, 2019
Latest reply on Feb 19, 2019 by bookalaka

Good Day,

I am trying to get the total of "Accounts Sold" from a report that is broken down by WEEK, CUSTOMER, and PRODUCT.

This solution Database Pros:List  almost gets me there.  My difference is I don't have one unique field "CATEGORY" to Count by.

 

I believe my solution is to count duplicate records as 1? and this I don't know how to do. Subsummary counts all records I just want 1 for each company.

 

Want to achieve  Accounts Sold = 2

 

WK1,   ABC COMPANY , PRODUCT A

WK1,   ABC COMPANY , PRODUCT B

WK1,   ABC COMPANY , PRODUCT C

 

WK1,   DEF COMPANY , PRODUCT C

WK1,   DEF COMPANY , PRODUCT C

WK1,   DEF COMPANY , PRODUCT C

WK1,   DEF  COMPANY , PRODUCT C

 

My attachment shows Accounts sold as 52 (This is Products Sold) the number should be 23

 

Thanks in advance for the support!

Attachments

Outcomes