I have data like the below in which i want to create a chart that will show me how many distinct items sold per customer name. So in the example below, Customer ABC sold 2 distinct items. Once that is done, i want to show how many customers sold 1 unique item, how many customers sold 2 unique items and how many customers sold 3 or more unique items.
How would I accomplish this.
Year Customer Name Item sold 2014 abc AA 2014 abc BB 2014 abc BB
2014 def AA
2014 ghi CC 2014 ghi AA 2014 ghi BB
2014 jkl AA
2014 mno BB 2014 mno CC 2014 mno AA
Customers who sold 1 unique item = 2 Customers who sold 2 unique items = 1 Customers who sold 3 or more unique items = 2
Re: Help getting a count of unique items sold by year
that kindof worked. I do a row for every customer as to how many items they sold. Now I need to put this in a chart so want to could how many customers sold only 1 item, how many customers only sold 2 items etc. similar to this. the gray would be the customers that sold 1 item, black is the customers that sold 2 items and the red are the customers that sold 3 or more.