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.
Hello,
Below is the data, please note that for each distinct SO Document that is B2B - price is $2.50, and for each distinct SO Document that is B2C - price is $1.65.
| S.O.Document | B2B/B2C |
| 36094812 | B2B |
| 36150140 | B2B |
| 36211362 | B2B |
| 36037098 | B2C |
| 36094813 | B2C |
| 36113575 | B2C |
| 36132013 | B2C |
| 36150156 | B2C |
| 36189237 | B2C |
| 36049426 | B2B |
| 36066981 | B2B |
| 36096529 | B2B |
| 36159728 | B2B |
| 36159733 | B2B |
| 36170533 | B2B |
| 36211343 | B2B |
| 36244071 | B2C |
| 36245048 | B2B |
| 36034609 | B2B |
| 36043892 | B2B |
| 36045997 | B2B |
| 36046243 | B2C |
| 36046444 | B2B |
| 36071046 | B2B |
| 36170505 | B2B |
| 35979970 | B2B |
| 36008473 | B2B |
| 36032993 | B2B |
| 36035768 | B2B |
| 36036393 | B2B |
| 36044494 | B2B |
| 36045814 | B2B |
| 36046268 | B2B |
| 36049434 | B2B |
| 36049435 | B2B |
| 36056082 | B2B |
| 36056085 | B2B |
| 36058503 | B2B |
| 36058504 | B2B |
| 36058513 | B2B |
| 36058515 | B2B |
| 36058516 | B2B |
| 36058517 | B2B |
| 36058518 | B2B |
| 36058519 | B2B |
Here in my table I have the # of distinct orders by B2B/B2C as you suggested above, but I cannot multiply out the price per # of distinct orders:
Thank you very much!