Sorting customer by sales amount for several times

Hello everybody,

I have one Problem with sorting by customer. I copied the formula from N12 (NL (sum) for sales amount) to C12 and used the Quote function. That field (C12) i use for sorting in G12.

During my tests i found out now, that the customers for the first item type are sorted correct. But for the other item types the report use also the same order for the customer, provided the customer is within the filter (see screenshot - both screenshots are from different data sources, hence the customer no are not the same.). Is it even possible, that the Report do a new sorting of the customer for every item type during calculation??? Or sort Jet Report only one time???

Attached I send you a screenshot where i have marked the relevant columns/rows. Also a list with customer No for some item types as example. Attached you find also the Report with values.

Thanks in advance.

Daniel

• Sorting Customer by sales amount.JPG
• CustNo per item type.JPG
• CUST003 Sales Amount by Salesperson and Item Type and Customer - Kopie.xlsx