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?

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:"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"yhoy" wrote:
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?