I have a table which essentially is:
- Category
- Item #
- Sales $
I'm looking for a query that will tell me the count of items that make up 80% of the sales per category (probably would have to use a subquery here). So if my table was:
item #, sales $
1, $10
2, $8
3, $6
4, $5
5, $1
Total...