Sort by multiple fields
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?
|