auto sort table base on maximum sale of each customer and orders of customer consecutive

With a pivot table (see the attached file).

You have to change the data in table 2, if you want a pivot table of that (i changed it => see the file).

I try again.

Maybe like this?

thanks
but it do not sort by maximum sale of each customer yet.

sara have maximum sale and she must in top of table.

thanks.

My last excel file show this table.


Rijlabels Som van saletotal
Sara 8.820,10
Antonio 8.195,10
Mark 7.943,10
Paul 3.865,90
Jenifer 3.378,40
Mary 3.225,60
Eindtotaal 35.428,20

1) If this is not what you want, you have to add the desired result in a excel file an post it here.

2) Or do you want a table like this?

Rijlabels Max van saletotal
Sara 4.003,40
Antonio 3.591,00
Jenifer 3.378,40
Mark 3.263,40
Mary 3.225,60
Paul 2.417,50
Eindtotaal 4.003,40

Excel 2007 => data => sort

See the example.

Now it is your turn to add the file as you liked it to be sorted.