2

I am using 'Store' as dissolve field and 'Profit' as statistics field with statistic type 'MAX', and would like to preserve the related 'Fruit'.

This is my original table:

____________________________
| Store |  Fruit  | Profit |
|   A   |  Orange |   20   |
|   A   |  Apple  |   30   |
|   B   |  Banana |   15   |
|   B   |  Grape  |   10   |
|   C   |  Apple  |   35   |

This is what I want:

________________________________
| Store |  Fruit  | MAX_Profit |
|   A   |  Apple  |     30     |
|   B   |  Banana |     15     |
|   C   |  Apple  |     35     |
  • Have you tried using the Summary Statistics tool? – PolyGeo May 6 '18 at 20:19
  • 1
    Sort by profit, delete duplicates by store. – FelixIP May 6 '18 at 20:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.