I am setting the regular aggregate property of a calculation non-numeric account numbers to CountDistinct, but when I test that column I only get the original account number account number. Can someone tell me what I should do to get the distinct count of accounts. Is that number going to reside on each row, meaning will it count all the distinct account numbers and then put that number on each row? I'm a little lost In how this works?
SOLVED!!
This problem was solved by putting the count distinct WITHIN the calculation itself as oppoesed to having a calculation, and making the property of Regular Aggregate to be "count Distinct: