how to classify according to the sum amount

[caolu1995]

Hi all,

The first table is my original data and I am trying to classify the amount of contracts. I used the function called count distinct to calculate the number of the clients, but it showed like below:

I know where the problem is, it seems that the dimension is not sum of the amount if it is from the same client. It should be like the second table.  I created a new dimension which function is : but it's not working.

=if(sum([contract amount])<'100000', '小于十万', 
	if(sum([contract amount])>'1000000','大于百万','十万至百万'))

anyone can help me solve this kind of problem? Maybe I should use the aggravation function?