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?
Solution
The count should be within the calculation itself as opposed to a property of the calculation