Lyndall Bradley
asked on
How to count the number of customers ordering at an item - pivot table
Column A: - Unique identification number of product
Column B: Departments ordering
I would like to count the number of departments ordering a unique product in Colum A
Column B: Departments ordering
I would like to count the number of departments ordering a unique product in Colum A
hmm ... why pivot ?
select A,count(B) from table group by A
select A,count(B) from table group by A
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oups : missed the excel part ;) sorry
if you need a formula for a specific product, something like this should do : count(if(A1:A100 = "myproduct",B1:B100))
if you need a formula for a specific product, something like this should do : count(if(A1:A100 = "myproduct",B1:B100))
ASKER
Thank-you for your replies.
The attached workbook. I would like to know how many times the customers in Colum B orders column A. Thank-you for your time and assistance.
The attached workbook. I would like to know how many times the customers in Colum B orders column A. Thank-you for your time and assistance.
you'd need to replace the "sum" by a "count" in the calculated data ( or add an extra column ).
click on the pivot and find where you can add a new "value" or "set of values" which will actually ask for the type of value ( sum, count, count unique ... ) and add the corresponding extra column.
click on the pivot and find where you can add a new "value" or "set of values" which will actually ask for the type of value ( sum, count, count unique ... ) and add the corresponding extra column.
Sample workbook would be helpful.