Sort by multiple fields

Y

yhoy

i have fields A, B and Value C. For each A there are multiple B. Goal is to
filter out the Maximum C for each combination of A and B. What I did:
- create a pivot table with A and B as ROW field
- drop C as data item

how to set up thus the maximum C always shows up on first line of the A&B
combination?
 
M

Max

Tinker with it like this (xl2003): Click on a cell below the rightmost field
in the ROW area (below the "B" field). Then from the PivotTable dropdown (on
the pivot toolbar), select: Sort and Top10. In the ensuing dialog, select the
Autosort option: descending, then choose the "C" field (from amongst those in
DATA) from the dropdown under "Using field:"
 
Top