none
Calculate distinct Customers who purchased a product RRS feed

  • Question

  • I need to calculate the distinct number of customers who purchased a product.

    I have a Customer table with CutomerKey, Cutomer Name

    Product table with ProductKey, product name, product class 

    sales table with Product key, Customer key, Sales Amount, Sales Units

    Is it possible to calculate the distinct number of customers who purchased a specific, selected product, and product class?


    John Schroeder

    Monday, October 21, 2019 4:31 PM

Answers