![1550910262036.jpg 1550910262036.jpg](https://community.qlik.com/t5/image/serverpage/image-id/6627i099BF992AB2E5DFA/image-size/medium?v=v2&px=400)
![1550910278857.jpg 1550910278857.jpg](https://community.qlik.com/t5/image/serverpage/image-id/6628iE5B16CD9BB0E187A/image-size/medium?v=v2&px=400)
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:![1550910457333.jpg 1550910457333.jpg](https://community.qlik.com/t5/image/serverpage/image-id/6629iFC8036F7106E5BE8/image-size/medium?v=v2&px=400)
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?