Forum Discussion
Need help for visual
- 5 years ago
Hi, kokoro_1202
Thank you for your feedback.
I thought product sold count = count of transaction ID -> Please correct me if I am wrong.
And, I counted distinct value of transaction ID -> For instance, in January, there is one transaction ID (TransactionID 48925007) shown twicein W67 mainstreet and 45TY mainstreet. I counted this as one value = distinct count.
If you want to count separately, instead of using "distinctcount", I can use "count".
Thank you very much.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
HI kokoro_1202
PFA the file below
- kokoro_12025 years agoHelper I
Anonymous
hihi, for Jan, total transaction is 20, but the number of product sold for HQ & high street are wrong?
For example: Jan should HQ=7 & Main street = 13.
Did I missed out anything?