the data is alike
A
B
C
A
when I count, I want to count how many distinct items, the result of above
data shouls show only 3 (A, B and C).
when I use pivot, the total shows 4 (counting 2 As).
Pls help how to get this done.