An example with different sort order for the two dimensions ia attached. Is this what you want to do?
Test0520.qvw 133.5 K
Your example describes the problem but unfortunalety not the solution
Customer B has the highest Sales overall (900 + 700 = 1600). That's why he is in first place for both Categories.
What I want is the following:
1 - A - 1100
1 - B - 900
1 - C - 750
2 - B - 700
2 - C - 500
2 - A - 400
the customers should be sorted by sales for each category different.