Is there a method to group by the sum of an item then count the number of occurrences of that sum?
There are multiple teams selling a product, say cookies. Each sale can have 1 or more cookies sold. Each sale notes a date and a sales team. I need to be able to sum the sales by team given a time frame and count the number of teams selling the same number of cookies.
May 2012 Cookie Sales
# Cookies Sold #Teams Selling that number of cookies
So I need to sum the sales by group for the time frame, then count the number of groups which have that sum of cookies sold.
I don’t want to use bins, or defined groups, as the total number of cookies sold could vary month by month or year by year depending on how I slice up the data.