I have a set of data in which i want to categorize based on a particular field into three groups which are small, medium and large.
i have two rows in the data, accountnumber and amount. One account number can come more than one time.
i have to find all the unique account numbers and there sum of amount.
then based on that i have to display the number of account in small, medium and large group.
the problem where i am facing is that , i have to create the groups based on a certain formula.i.e in the small group i will be having the number of account number which are having the amount less than the mean. medium group will have from mean to 2* standard deviation. while all rest will be in three.
Something like in the attached?