Forum Discussion
Distinct Count
Im using ditinct count for my cust count column im wondering why its showing me multiple counts
2 Replies
Which column are you using inside the DISTINCTCOUNT()? If customer name/id then it shows you have multiple customers buying that item in that store.
Pat
The column 'cust count' is my customer ID. and I switched it to distinct count so it only shows a single customer for that item once....it works for most of my customers.
Under item No. are all the customers expanded shown once when I use the distinct count coloumn for 'Cust Count' long side my names.. my names are showing up once which is What im looking for in count as well showing only 1's.. almost most of my other counts show ones line below its the few of the others
