Problem with segmentation / grouping up data

Hi v-jiascu-msft

Well the problem is that all the columns data is in Dutch, so that makes it hard to read for you. Secondly, the company that doens't allow me to share the data. 

I shall make my question more accurate. I want to make a segmentation in my costumers table from the data of my salestable. The two tables have a one to many relationship. I can get the total sales per custumer (just a normal sumx) in a calculated colum in my costumers table. I can make a formula that puts the costumer in groups (if or switch function) but these don't respond correctly when I put the segmentation in the pivottable (as a row). If for example, a costumer has 700k revenue, it still goes in the segmentation big (>1.000.000 revenue). I think this is because my costumers table has a "one" relationship. I can't make a formula that ignores the relationship or something, that it puts the costumer in the right segementation.

Unfortunalty I cannot put a picture in this massage, what would have made it a lot easier to understand.

Thank you for your help.