Forum Discussion
Solved
Countrows from Distinctcount from another column
Hi All, I'm trying to do a count of all values from one column... got that, not a problem. The problem is that I need my new count based on a distinct count from another column. For example col...
Good to know that you can solve your question.
Please accept the solution to others con use you.
Victor, thank you very much! That works, but now I am stuck to figure out how to make a cost calculation. B2B = $2.50 ea, and B2C = $1.65 ea. I'm not sure how to get that in there. I have a calculated column with the value (price) for each, but not sure how to make it multiply by only B2B and distinct # of orders, and B2C??
Vvelarde
Community Champion
Community Champion