2 Replies Latest reply: Jul 12, 2010 9:59 AM by saulthomas RSS

    Counting the number of occurrences of a particular value

      My problem is thus;

      I have a table chart with following fields 'Account Holder ID' and 'Number of Accounts' (count(AccountNumber)). I would like if possible to build a table where it shows 'Number of Accounts' and 'Count of Account Holder ID' so that I can say, for example, there are 5 people wih 4 accounts, 10 people with 3 accounts and 1000 people who have only one account.

      It makes no difference to me whether calculations occur within load script or within the table expressions.

      Thank you in advance. Saul.